X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 1B311D1DBC9
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 16 Feb 2004 15:34:31 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 57284-08
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 16 Feb 2004 11:34:29 -0400 (AST)
Received: from sss.pgh.pa.us (unknown [192.204.191.242])
	by svr1.postgresql.org (Postfix) with ESMTP id 5BC0FD1C513
	for <pgsql-sql@postgresql.org>; Mon, 16 Feb 2004 11:34:24 -0400 (AST)
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i1GFYIP4025771;
	Mon, 16 Feb 2004 10:34:18 -0500 (EST)
To: "Mark Roberts" <RoberM1@gosh.nhs.uk>
Cc: pgsql-sql@postgresql.org
Subject: Re: Date format problems 
In-reply-to: <s030c05a.023@smtp.gosh.nhs.uk> 
References: <s030c05a.023@smtp.gosh.nhs.uk>
Comments: In-reply-to "Mark Roberts" <RoberM1@gosh.nhs.uk>
	message dated "Mon, 16 Feb 2004 13:06:22 +0000"
Date: Mon, 16 Feb 2004 10:34:18 -0500
Message-ID: <25770.1076945658@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200402/199
X-Sequence-Number: 16889

"Mark Roberts" <RoberM1@gosh.nhs.uk> writes:
> Hi im using the function below to insert data into my db; im using
> now() to get the timestamptz, however when inserted in the db the format
> seems to vary, the majority of the time its in the required European
> style but does spontaniously change to various other type can anyone
> throw any light on this problem. 

This is way too vague for anyone to help.  What PG version are you
using?  What is the actual datatype of the column you're inserting into?
Can you provide a specific example of a misformatted data value?

			regards, tom lane