Hi, CURRENT_DATE - 1, same as CURRENT_DATE - 0.5 and DATEADD, returns a timestamp.
Regards, Thomas On Sat, Aug 31, 2013 at 3:49 PM, Noel Grandin <[email protected]> wrote: > > > > On Sat, Aug 31, 2013 at 9:04 AM, Cecil Westerhof > <[email protected]>wrote: > >> Does not make a difference (besides making the query bigger): >> SELECT CURRENT_DATE, CURRENT_DATE - 1, DATEADD('DAY', -1, >> CURRENT_DATE) >> gives: >> 2013-08-31, >> 2013-08-30 00:00:00.0, >> 2013-08-30 00:00:00.0 >> >> > Looks you got the right answer there - the last date is 24 hours in the > past ?? > > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
