[sconan]

Hey Guys,

In the older ODBC tools (Putty sessions and all), I could use ‘sysdate’ in the query to get today’s date. I can’t seem to find a way to do it using the new Windows version of the ODBC connector. Any suggestions?

Thanks,

Scott
This is a cached copy. Click here to see the original post.

[Rajesh Seth]

RE: New ODBC Connection (OpenRDA) and current date

Hi Scott,

try,

select current_date;

[Rajesh Seth]

RE: New ODBC Connection (OpenRDA) and current date

Sorry,

ignore last post. I think that was specific to my client, not ODBC in general

[ivan.parra]

RE: New ODBC Connection (OpenRDA) and current date

getdate() should return the current date.

Issues have been filed to support other names for the date type, for example sysdate(), current_date, etc.

[mshuman]

RE: New ODBC Connection (OpenRDA) and current date

It appears that getdate returns Pacific Time, but all times are recorded in UTC. Is there a way to do a getutcdate? That function specifically doesn’t work, but I’m looking for an alternative.

[Author]

Posts