On Thu, Jan 16, 2003 at 10:58:24 -0000, d ravipati <[EMAIL PROTECTED]> wrote: > Hi, > Is there any command to find database server local time zone > alone. > > SHOW TIME ZONE just displays database servers local time zone. > But I need to hold output of SHOW TIME ZONE in a variable, to > convert the input given in GMT to database server time zone. > Is there any other way to get database server time zone? > Thanks > Devi
If the input timestamp includes a timezone specification indicating GMT, you shouldn't have to do anything. If the timestamp is a string without timezone information, you should be able to manipulate the string to indicate that it is GMT. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
