The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

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.3k9129262
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.3k287438644
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,258 times

last updated: 26 Oct '13, 03:58