On Mon, Feb 13, 2006 at 04:18:30PM -0500, Goulet, Dick wrote:
> If your using V7.4 it doesn't but the following will create one.
Eh? to_date(text, text) is documented as far back as 7.0, and it
certainly works on the 7.4 and 7.3 systems I checked.
http://www.postgresql.org/docs/7.4/static/functi
PROTECTED] On Behalf Of Jim
FuSent: Monday, February 13, 2006 3:45 PMTo:
pgsql-admin@postgresql.orgSubject: [ADMIN]
to_date
I am new here, just
wondering if PostgreSQL has a similar function TO_DATE
(‘02/12/2006’,’mm/dd/’)?
Thanks!
Jim
Fu
On Mon, 2006-02-13 at 15:22, Jim Fu wrote:
> Thank you Michael for the info!
>
> I have the original date info as mmddyy, when I use copy tabname from
> filename, it fails due to mismatch between raw date info and date data type
> in the database. It seems like I had to convert the raw date info
reSQL date default format in order to use copy
command.
-Original Message-
From: Michael Fuhr [mailto:[EMAIL PROTECTED]
Sent: Monday, February 13, 2006 3:12 PM
To: Jim Fu
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] to_date
On Mon, Feb 13, 2006 at 02:44:45PM -0600, Jim Fu wrote:
On Mon, Feb 13, 2006 at 02:44:45PM -0600, Jim Fu wrote:
> I am new here, just wondering if PostgreSQL has a similar function
> TO_DATE ('02/12/2006','mm/dd/')?
Yes:
test=> select to_date('02/12/2006','mm/dd/');
to_date
2006-02-12
(1 row)
The documentation describes the
I am new here, just wondering if
PostgreSQL has a similar function TO_DATE (‘02/12/2006’,’mm/dd/’)?
Thanks!
Jim Fu
