sqlite - Date And Time Functions

Not logged in

• Honeypot
• Browse
• Home
• Login
• Reports
• Search
• Ticket
• Timeline
• Wiki

• Contents
• No-Diff
• Text

*** 155,165 ****
  
    SELECT julianday('now')*86400 - julianday('2004-01-01 02:34:56')*86400;
  
! Compute the date of the first Tuesday in October for the current
  year.
- _Wrong, Actually this returns 2004-11-02 (November)_
  
!   SELECT date('now','start of year','+10 months','weekday 2');
  
  *Caveats And Bugs*
  
--- 155,164 ----
  
    SELECT julianday('now')*86400 - julianday('2004-01-01 02:34:56')*86400;
  
! Compute the date of the first Tuesday in October (January + 9) for the current
  year.
  
!   SELECT date('now','start of year','+9 months','weekday 2');
  
  *Caveats And Bugs*