| From: | "Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)com> |
|---|---|
| To: | <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Make year 01/01/0001 but leave timestamp alone |
| Date: | 2005-08-02 15:49:19 |
| Message-ID: | 4A59B6AA01F1874283EA66C976ED51FC4663BB@COENGEXCMB01.cable.comcast.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith Worthington | 2005-08-02 16:14:56 | Re: Make year 01/01/0001 but leave timestamp alone |
| Previous Message | Johan C. de Koning | 2005-08-02 08:02:32 | Retrieving images from Postgres with C++ |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith Worthington | 2005-08-02 16:14:56 | Re: Make year 01/01/0001 but leave timestamp alone |
| Previous Message | Tom Lane | 2005-08-02 01:48:12 | Re: Calling SQL functions that return sets |