nt: Friday, March 03, 2006 4:32 PM
To: Davidson, Robert
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Getting yyyy-mm-dd 00:00:00 in an arbitrary time zone
"Davidson, Robert" <[EMAIL PROTECTED]> writes:
> I am trying to find out what the last full day of data for an
> arbitra
"Davidson, Robert" <[EMAIL PROTECTED]> writes:
> I am trying to find out what the last full day of data for an arbitrary =
> timezone (generally not the pg client's timezone). I get the =
> max(timestamp), then would like to remove the time portion. Sounded like =
> a job for date_trunc, unfortunat
Title: Getting -mm-dd 00:00:00 in an arbitrary time zone
I am trying to find out what the last full day of data for an arbitrary timezone (generally not the pg client's timezone). I get the max(timestamp), then would like to remove the time portion. Sounded like a job for date_trunc, unfo