Timeline for SQL database with temporal data
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 26, 2012 at 17:48 | comment | added | HLGEM | Actaully this would only get the people born at midnight unless you are using SQL Server's date data type and not datetime. If you have times associated, you would want date>='1970-01-01' AND date<'1970-01-02' | |
| Mar 26, 2012 at 15:29 | comment | added | Leigh Riffel |
Oracle would accept either of these as well assuming the proper NLS_DATE_FORMAT.
|
|
| Mar 26, 2012 at 14:26 | vote | accept | mariomario | ||
| Mar 26, 2012 at 14:00 | history | answered | gbn | CC BY-SA 3.0 |