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

asked 25 Oct '13, 11:50

sqlgeek's gravatar image

sqlgeek
1477713
accept rate: 0%


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%20Culp's gravatar image

Mark Culp
22.5k9129265
accept rate: 40%

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%20Barth's gravatar image

Volker Barth
29.6k293444650
accept rate: 32%

edited 26 Oct '13, 03:58

Your answer
toggle preview

Follow this question

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:

×34

question asked: 25 Oct '13, 11:50

question was seen: 2,361 times

last updated: 26 Oct '13, 03:58