MS SQL "isDate" equivalent in plpgsql?

From: "Daniel Gehrke" <DGehrke(at)neusta(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: MS SQL "isDate" equivalent in plpgsql?
Date: 2003-05-15 15:41:57
Message-ID: 5gc0ab.bss.ln@igate28.intern.neusta.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

I am not sure if this is the right newsgroup. If not, please excuse, I
didn't find one, that'ld fit better. *g*

I am porting from MS SQL 7.0 to PostgreSQL. In one Stored Procedure the
function "isDate" is used. IsDate determines, whether the input string is a
date or not:

select isdate('05.15.2003');
Result: 1
select isdate('foobar');
Result: 0

Is there a function in plpgsql like that?
Maybe someone has a self-written function that implements that?

Thanks in advance and regards,
Daniel

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steve Crawford 2003-05-15 15:45:46 Re: How do I view the logs?
Previous Message Nigel J. Andrews 2003-05-15 15:33:50 Re: How do I view the logs?