Re: [NOVICE] Make year 01/01/0001 but leave timestamp alone - Mailing list pgsql-sql

From daq
Subject Re: [NOVICE] Make year 01/01/0001 but leave timestamp alone
Date
Msg-id 16139676609.20050802182227@ugyvitelszolgaltato.hu
Whole thread Raw
List pgsql-sql
WJS> I have a situation where we have a timestamp column but in special cases
WJS> we want to set the date to '01/01/0001' and leave the timestamp alone.
WJS> For example, '11/04/2005 10:30:05' would become '01/01/0001 10:30:05'.
WJS> I've been going through the various date time functions but don't see a
WJS> simple way to do this. Can someone help?

WJS> Thanks,

WJS> Jed

Maybe... Chomp the date part and concatenate the timestamp with
'01/01/0001'

DAQ



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Calling SQL functions that return sets
Next
From: Henry Ortega
Date:
Subject: Breakdown results by month