MS SQL Date Functions

69 views
Skip to first unread message

Andy Lahan

unread,
Feb 5, 2020, 10:31:08 AM2/5/20
to H2 Database
Hi,

I'm starting to use H2 in my local test environment in MSSQLServer mode and have found that SYSUTCDATETIME() and GETUTCDATE() are not supported. Is there any way round this?

Cheers
Andy

Evgenij Ryazanov

unread,
Feb 5, 2020, 10:59:29 AM2/5/20
to H2 Database
Hello.

You can create user-defined functions with such names by using the CREATE ALIAS command:
Reply all
Reply to author
Forward
0 new messages