Make year 01/01/0001 but leave timestamp alone - Mailing list pgsql-novice

From Walker, Jed S
Subject Make year 01/01/0001 but leave timestamp alone
Date
Msg-id 4A59B6AA01F1874283EA66C976ED51FC4663BB@COENGEXCMB01.cable.comcast.com
Whole thread Raw
Responses Re: Make year 01/01/0001 but leave timestamp alone
Re: Make year 01/01/0001 but leave timestamp alone
List pgsql-novice

I have a situation where we have a timestamp column but in special cases we want to set the date to '01/01/0001' and leave the timestamp alone. For example, '11/04/2005 10:30:05' would become '01/01/0001 10:30:05'. I've been going through the various date time functions but don't see a simple way to do this. Can someone help?

Thanks,

Jed

pgsql-novice by date:

Previous
From: "Johan C. de Koning"
Date:
Subject: Retrieving images from Postgres with C++
Next
From: "Keith Worthington"
Date:
Subject: Re: Make year 01/01/0001 but leave timestamp alone