Christopher,
> I tried it on my SQLServer and Oracle DB:
> select * from SomeTable
> where SomeDateTime < {ts '2012-02-06 20:48:59'}
>
> and it worked. Learning something new every day!
I had seen this peculiar format before. The Derby database (JavaDB)
makes extensive use of it also for functions....
http://db.apache.org/derby/docs/10.7/ref/rrefjdbc88908.html
So far, I hadn't given this much attention apart from Derby function
compatibility, but now it seems quite useful. Thanks for the hint!
Cheers
Lukas