In sybase ASE, there is GMT time function but not in Sybase IQ.
Is there an alternative to get GMT time in sybase IQ??
asked 25 Oct '13, 11:50
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.)