convert string to time object for postgress, help please!

[php_new]

Hi all,

I have a string like this "02/23/2003" --"mm/dd/yyyy"

And I would like to compare this string to a time object in postgress (on linux).

Any suggestions? Thanks

Scott

[php_new]

Perhaps I need to clarify this.

I need to conver the string to time object can compare to one time object in SQL query.

Thanks

Scott

[php_new]

up

[Weedpacket]

You're asking for two things:
(1) Get date information out of that string. Because it's an ambiguous format, you'll have to do it manually: there are a number of threads on this subject: search for parse date string to find some.

(2) Put that date information into a PostgreSQL query: how to do this depends on PostgreSQL, the preferred format for which is the ISO standard 'yyyy-mm-dd'. Put the year, month, and day into a string like that, put that string into the SELECT query.