Thread: Select current_timestamp as a different timezone..
All, Is there a way to do this? Take current_timestamp (which on my box is CST) and select it as maybe EST? Travis
Williams, Travis L, NPONS wrote: > All, Is there a way to do this? Take current_timestamp (which on my > box is CST) and select it as maybe EST? > See: http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/functions-datetime.html#FUNCTIONS-DATETIME-ZONECONVERT Section 6.8.3. AT TIME ZONE HTH, Joe
Thanks.. I was looking in the 7.2 documentation and didn't see.. either that or I'm blind!! Travis -----Original Message----- From: Joe Conway [mailto:mail@joeconway.com] Sent: Tuesday, April 22, 2003 6:23 PM To: Williams, Travis L, NPONS Cc: pgsql-novice@postgresql.org Subject: Re: [NOVICE] Select current_timestamp as a different timezone.. Williams, Travis L, NPONS wrote: > All, Is there a way to do this? Take current_timestamp (which on my > box is CST) and select it as maybe EST? > See: http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/functions-da tetime.html#FUNCTIONS-DATETIME-ZONECONVERT Section 6.8.3. AT TIME ZONE HTH, Joe
Ok.. I have another question about time zones.. Is there a way to tell if someone who use daylight savings time is currently in daylights savings time (i.e. If I'm converting time should I convert my time to EST or EDT?) or am I going to have to manually decide if they are in DST or not? Just playing around it doesn't look like postgres looks at whether they are in dst or not.. it just does the math based on the table. Travis -----Original Message----- From: Williams, Travis L, NPONS Sent: Tuesday, April 22, 2003 6:25 PM To: Joe Conway Cc: pgsql-novice@postgresql.org Subject: Re: [NOVICE] Select current_timestamp as a different timezone.. Thanks.. I was looking in the 7.2 documentation and didn't see.. either that or I'm blind!! Travis -----Original Message----- From: Joe Conway [mailto:mail@joeconway.com] Sent: Tuesday, April 22, 2003 6:23 PM To: Williams, Travis L, NPONS Cc: pgsql-novice@postgresql.org Subject: Re: [NOVICE] Select current_timestamp as a different timezone.. Williams, Travis L, NPONS wrote: > All, Is there a way to do this? Take current_timestamp (which on my > box is CST) and select it as maybe EST? > See: http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/functions-da tetime.html#FUNCTIONS-DATETIME-ZONECONVERT Section 6.8.3. AT TIME ZONE HTH, Joe ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
or maybe I'm being at idiot and didn't realize we are currently in DST!!!.. Travis -----Original Message----- From: Williams, Travis L, NPONS Sent: Tuesday, April 22, 2003 6:39 PM To: Williams, Travis L, NPONS; Joe Conway Cc: pgsql-novice@postgresql.org Subject: Re: [NOVICE] Select current_timestamp as a different timezone.. Ok.. I have another question about time zones.. Is there a way to tell if someone who use daylight savings time is currently in daylights savings time (i.e. If I'm converting time should I convert my time to EST or EDT?) or am I going to have to manually decide if they are in DST or not? Just playing around it doesn't look like postgres looks at whether they are in dst or not.. it just does the math based on the table. Travis -----Original Message----- From: Williams, Travis L, NPONS Sent: Tuesday, April 22, 2003 6:25 PM To: Joe Conway Cc: pgsql-novice@postgresql.org Subject: Re: [NOVICE] Select current_timestamp as a different timezone.. Thanks.. I was looking in the 7.2 documentation and didn't see.. either that or I'm blind!! Travis -----Original Message----- From: Joe Conway [mailto:mail@joeconway.com] Sent: Tuesday, April 22, 2003 6:23 PM To: Williams, Travis L, NPONS Cc: pgsql-novice@postgresql.org Subject: Re: [NOVICE] Select current_timestamp as a different timezone.. Williams, Travis L, NPONS wrote: > All, Is there a way to do this? Take current_timestamp (which on my > box is CST) and select it as maybe EST? > See: http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/functions-da tetime.html#FUNCTIONS-DATETIME-ZONECONVERT Section 6.8.3. AT TIME ZONE HTH, Joe ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly