Thread: Re: [NOVICE] Make year 01/01/0001 but leave timestamp alone

Re: [NOVICE] Make year 01/01/0001 but leave timestamp alone

From
daq
Date:
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