Time convertion b/w BST to GMT

Advertisement

Time convertion b/w BST to GMT
Hi Guys,
Is there any Oracle function to convert British time Zone(BST) to Green wich meen time Zone(GMT).
if it is there would you please help me by Explaining that..
I need to covert Trade execution time from BST to GMT wich should Need to be in GMT.
Thankx In Advance...
thankx,
Lakshmi.
Repaly
Hi and welcome to the forum!
Your question has been asked before, see f.i.:
Re: Converting Date to timestamp with time zone
(Do some more searches on this forum to find more examples)
Read all about TIMESTAMP, CAST, FROM_TZ @ http://tahiti.oracle.com (the Oracle Documentation).
If that doesn't get you going, then please post your DB-version and your efforts sofar.
Read More: The other 2 answers