Which function can I use

[didley@…]

I'm using for a query statement below

<= strftime('%s','2011-05-31 23:59:59')

I'm not a professional user of SQL-Queries. I tried

<= strftime('%s',datenow())

I got the message function is unknown. Do you know which function I should use to get the current date?

didley

[Ryan J Ollos]

I'm fairly sure this will be database dependent. ​Here are the functions you can use in SQLite, and an example (for Trac 0.12+, in earlier versions remove the divide by 1000000):

{{{
#!SQLTable
  SELECT datetime(time/1000000, 'unixepoch', 'localtime') AS time
  FROM ticket
  WHERE id=1
}}}

If you have further questions, please raise the issue on the mailing list. There you are likely to find people that can answer this question better than I can.