Get GMT time in sybase IQ

1	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 sybase-iq asked 25 Oct '13, 11:50 sqlgeek 147●7●7●13 accept rate: 0% flat view

2 Answers:

1	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 permanent link answered 25 Oct '13, 14:21 Mark Culp 25.0k●10●142●298 accept rate: 41% flat view

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

permanent link

answered 25 Oct '13, 14:11

Volker Barth
40.5k●365●556●827
accept rate: 34%

flat view

Your answer

toggle preview

community wiki:

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

Question tags:

question asked: 25 Oct '13, 11:50

question was seen: 6,330 times

last updated: 26 Oct '13, 03:58

SAP SQL Anywhere