sqlite - Date And Time Functions

Not logged in

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

• Contents
• No-Diff
• Text

*** 135,143 ****
  
    SELECT date('now','start of month','+1 month','-1 day');
  
! Compute the date and time given a unix timestamp X.
  
!   SELECT datetime(X, 'unixepoch');
  
  Compute the current unix timestamp.
  
--- 135,147 ----
  
    SELECT date('now','start of month','+1 month','-1 day');
  
! Compute the date and time given a unix timestamp 1092941466.
  
!   SELECT datetime(1092941466, 'unixepoch');
! 
! Compute the date and time given a unix timestamp 1092941466, and compensate for your local timezone.
! 
!   SELECT datetime(1092941466, 'unixepoch', 'localtime');
  
  Compute the current unix timestamp.