Print Thread
Query Builder does not support 'timestamp at time zone'
#43121 01/13/12 12:52 PM
Joined: Jan 2003
Posts: 88
A
andyh Offline OP
Member
OP Offline
Member
A
Joined: Jan 2003
Posts: 88
Hi,

SELECT systimestamp at TIME ZONE 'Chile/Continental'
FROM dual

causes the Query Builder to complain about the 'at'.


Andy
Re: Query Builder does not support 'timestamp at time zone'
andyh #43129 01/16/12 01:00 PM
Joined: Aug 1999
Posts: 22,221
Member
Offline
Member
Joined: Aug 1999
Posts: 22,221
I assume you are using the Active Query Builder Plug-In?


Marco Kalter
Allround Automations
Re: Query Builder does not support 'timestamp at time zone'
Marco Kalter #43883 05/03/12 03:16 PM
Joined: Jan 2003
Posts: 88
A
andyh Offline OP
Member
OP Offline
Member
A
Joined: Jan 2003
Posts: 88
Ah, yes... the Active Query Builder plug-in.

Sorry, hadn't realized that it was a plug-in - I'll go an pester the correct people!


Andy

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.083s Queries: 14 (0.024s) Memory: 2.5004 MB (Peak: 3.0394 MB) Data Comp: Off Server Time: 2024-05-21 19:12:53 UTC
Valid HTML 5 and Valid CSS