You can use CURRENT UTC TIMESTAMP to get the current time in UTC. Example
returns
answered 25 Oct '13, 14:21 Mark Culp |
Don't know for IQ, however, the IQ front end (i.e. SQL Anywhere) does support a particular special value: SELECT CURRENT UTC TIMESTAMP (Note: SELECT CURRENT TIMESTAMP would be equivalent to SELECT GETDATE() - and both are available in SQL Anywhere. GetUtcDate() is not.) answered 25 Oct '13, 14:11 Volker Barth |