Octavian Rasnita wrote:
Is the following SQL
< TIMEDIFF( NOW(), ? SECONDS
a standard SQL code supported by more databases?
Until now I was using SQL codes like
< now() - interval ? second
but I am not sure if the keyword "interval" is used in other databases
than MySQL.
Thanks.
Octavian
Dates and times are some of the least standardized though commonly used types
and operators in SQL. So you generally have to assume that each DBMS does it
their own way and work accordingly, though some similarities may exist.
Also, the INTERVAL keyword is in the SQL standard; it is badly named though,
given that an INTERVAL in SQL isn't an interval (pair of ordered endpoints) at
all, but rather is a duration (an amount of time).
-- Darren Duncan
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk