Re: to_date - Mailing list pgsql-admin

From Goulet, Dick
Subject Re: to_date
Date
Msg-id 4001DEAF7DF9BD498B58B45051FBEA65032FBC28@25exch1.vicorpower.vicr.com
Whole thread Raw
In response to to_date  ("Jim Fu" <Jim.Fu@LogixCom.com>)
Responses Re: to_date
List pgsql-admin
If your using V7.4 it doesn't but the following will create one.
 
CREATE OR REPLACE FUNCTION to_date(text, text)
  RETURNS "timestamp" AS
'begin
return to_timestamp($1, $2);
end;'
  LANGUAGE 'plpgsql' STABLE STRICT;


From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Jim Fu
Sent: Monday, February 13, 2006 3:45 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] to_date

I am new here, just wondering if PostgreSQL has a similar function TO_DATE (‘02/12/2006’,’mm/dd/yyyy’)?

 

Thanks!

 

Jim Fu

pgsql-admin by date:

Previous
From: postgres@pivert.org
Date:
Subject: Re: Switch log (WAL)
Next
From: Michael Fuhr
Date:
Subject: Re: to_date