Get GMT time in sybase IQ

[Former Member]

Hi,

In sybase ASE, there is GMT time function but not in Sybase IQ.

select getutcdate()

Is there an alternative to get GMT time in sybase IQ??

Thanks

[MarkCulp · Accepted solution]

You can use CURRENT UTC TIMESTAMP to get the current time in UTC. Example

select CURRENT UTC TIMESTAMP;

returns

2013-10-25 18:12:16.340+00:00

[VolkerBarth]

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.)