> template1=# insert into t values ('1993-08-10 17:48:41');
> INSERT 16980 1
So we are talking about August 10th, right?
> template1=# select f1, date(f1), f1::date, cast(f1 as date) from t;
> f1 |date| f1 | f1
> -++
On Wed, 2003-07-23 at 12:48, Patrick Welche wrote:
> On Wed, Jul 23, 2003 at 01:36:52PM -0400, [EMAIL PROTECTED] wrote:
> > Hi all,
> >
> > I am trying to convert a timestamp field to a date. ('1993-08-10
> > 17:48:41.074' to '1993-08-10').
> > I used date(TIMESTAMP_FIELD), but it seemed working
On Wed, Jul 23, 2003 at 01:36:52PM -0400, [EMAIL PROTECTED] wrote:
> Hi all,
>
> I am trying to convert a timestamp field to a date. ('1993-08-10
> 17:48:41.074' to '1993-08-10').
> I used date(TIMESTAMP_FIELD), but it seemed working only for date
> after year 2000 and return the previous date
>
