X-Original-To: pgsql-novice-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 629E1529BB
	for <pgsql-novice-postgresql.org@localhost.postgresql.org>;
	Tue,  2 Aug 2005 12:49:47 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 35806-02
	for <pgsql-novice-postgresql.org@localhost.postgresql.org>;
	Tue,  2 Aug 2005 15:49:41 +0000 (GMT)
Received: from cable.comcast.com (paoakoavas09.cable.comcast.com
	[208.17.35.58])
	by svr1.postgresql.org (Postfix) with ESMTP id 81646529BF
	for <pgsql-novice@postgresql.org>; Tue,  2 Aug 2005 12:49:39 -0300 (ADT)
Received: from ([10.52.116.30])
	by paoakoavas09.cable.comcast.com with ESMTP  id KP-TDCH7.12632528;
	Tue, 02 Aug 2005 11:49:20 -0400
Received: from COENGEXCMB01.cable.comcast.com ([10.168.220.1]) by
	PAOAKEXCSMTP01.cable.comcast.com with Microsoft
	SMTPSVC(6.0.3790.211); Tue, 2 Aug 2005 11:49:20 -0400
X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C59779.BE782C13"
Subject: Make year 01/01/0001 but leave timestamp alone
Date: Tue, 2 Aug 2005 09:49:19 -0600
Message-ID: 
 <4A59B6AA01F1874283EA66C976ED51FC4663BB@COENGEXCMB01.cable.comcast.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Make year 01/01/0001 but leave timestamp alone
Thread-Index: AcWXeb5x9ZUvYHiCT6OPuIFsMcs1aQ==
From: "Walker, Jed S" <Jed_Walker@cable.comcast.com>
To: <pgsql-novice@postgresql.org>
X-OriginalArrivalTime: 02 Aug 2005 15:49:20.0433 (UTC)
	FILETIME=[BF2F9210:01C59779]
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.062 tagged_above=0 required=5 tests=AWL, HTML_50_60,
	HTML_MESSAGE
X-Spam-Level: 
X-Archive-Number: 200508/8
X-Sequence-Number: 14029

This is a multi-part message in MIME format.

------_=_NextPart_001_01C59779.BE782C13
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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



------_=_NextPart_001_01C59779.BE782C13
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
6.5.7226.0">
<TITLE>Make year 01/01/0001 but leave timestamp alone</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->

<P><FONT SIZE=3D2 FACE=3D"Arial">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?</FONT></P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks,</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Jed</FONT>
</P>
<BR>

</BODY>
</HTML>
------_=_NextPart_001_01C59779.BE782C13--