DATE (TIMESTAMP) stuff
(login)Requires JAVA 1.5 or later if you do not see anything above make sure you have java
-
Description
how to insert a date from the gui -
Stats
- Created:Feb 10 2008
- Public:Yes
- Audio:Yes
- Language:English
- Views:22
- Rating:
URL
-
Embed code
Choose width:
-
Export Video (.mov)
 
 
 
-
Notes
- 1:00Dates in NextDB are composite date-time datatypes, represented in the following format: YYYY-MM-DD hh:mm:ss.mmm TIMEZONE
-
(
= comment is from screencast creator)Comments
More/Less Add A Comment


60 Second Intro
Web 2.0 Conference Update
An example of a Date that you might insert, or update, is 2008-01-15 09:05:34.094 PST. The meaning of this date is “January 15, 2008 at 9:34 and 34 seconds and 94 milliseconds, Pacific Standard Time. When a query returns a Date, the timezone of the date is set to Greenwich Mean Time (GMT). The JavaScript returns Dates as Localized JavaScript Date Objects. The JavaScript API also uses http://www.datejs.com/ which is a great date parsing library for JavaScript.