SQLite CVSTrac

*** 62,77 ****
  2: YYYY-MM-DD HH:MM
  3: YYYY-MM-DD HH:MM:SS
  4: YYYY-MM-DD HH:MM:SS.SSS
! 5: HH:MM
! 6: HH:MM:SS
! 7: HH:MM:SS.SSS
! 8: now
! 9: DDDD.DDDD
  
! Formats 5 through 7 that specify only a time assume a date of 2000-01-01.
! Format 8, the string 'now', is converted into the current date and time.
  Universal Coordinated Time (UTC) is used.
! Format 9 is the julian day number expressed as a floating point value.
  
  _Please be sure to address Ticket #415 so we get full millisecond precision in julian day numbers. 
  Unfortunately this may mean adjusting some expression test cases that depend on values rounded to 
--- 62,81 ----
  2: YYYY-MM-DD HH:MM
  3: YYYY-MM-DD HH:MM:SS
  4: YYYY-MM-DD HH:MM:SS.SSS
! 5: YYYY-MM-DDTHH:MM
! 6: YYYY-MM-DDTHH:MM:SS
! 7: YYYY-MM-DDTHH:MM:SS.SSS
! 8: HH:MM
! 9: HH:MM:SS
! 10: HH:MM:SS.SSS
! 11: now
! 12: DDDD.DDDD
  
! In formats 5 through 7, the "T" is a literal character separating the date and the time, as required by the ISO-8601 standard. These formats are supported in SQLite 3.2.0 and later.
! Formats 8 through 10 that specify only a time assume a date of 2000-01-01.
! Format 11, the string 'now', is converted into the current date and time.
  Universal Coordinated Time (UTC) is used.
! Format 12 is the julian day number expressed as a floating point value.
  
  _Please be sure to address Ticket #415 so we get full millisecond precision in julian day numbers. 
  Unfortunately this may mean adjusting some expression test cases that depend on values rounded to

sqlite - Date And Time Functions