On 2013-02-19 15:19, Govanni Naessens wrote:
Hi,
Is it possible to change the behavior of the SYSDATE /function/.
I tried to create a /new/ alias via:
create alias "SYSDATE" for ...
Sorry, no.
... but then I get a
org.h2.jdbc.JdbcSQLException: Function alias "SYSDATE" already exists;
SQL statement
Evidently I'm only trying to change this behavior for testing purposes.
My creationDate columns are always inserted with a /sysdate /so I
would like to test several sysdates so I can search objects older then ...
Anyone any ideas?
UPDATE your_table SET creation_date = ? WHERE ID = ?
--
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
