Hualan Rui | 31 Oct 2008 15:09
Picon
Favicon

[Fwd: Why "to_date" is not working with pypgsql?]

Why the query "select starttime from dataproduct" is working fine with 
pypgsql, but the query "select to_date(starttime, 'DD-Mon-YYYY') from 
dataproduct" is not? What is the problem with the 'to_date"?

Any one can help? Please. Thank you!

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
johnf | 10 Nov 2008 01:56

Re: [Fwd: Why "to_date" is not working with pypgsql?]

On Friday 31 October 2008 07:09:28 am Hualan Rui wrote:
> to_date

Could it be that starttime is not 'text' data type?

--

-- 
John Fabiani

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/

Gmane