New topic: problem return timestamp data with SELECT in PostgreSQL
<http://forums.realsoftware.com/viewtopic.php?t=38713> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message Rocky Scofield Post subject: problem return timestamp data with SELECT in PostgreSQLPosted: Thu Apr 21, 2011 10:27 am Joined: Tue Nov 01, 2005 9:58 am Posts: 117 Hello, has anyone had trouble (or success) returning the contents of a timestamp field using the PostgreSQL plugin? I am using a straight SELECT statement. The recordset returns NIL for all timestamps whether they are with or without time zone. When I copy and paste the exact same SQL statement in other programs like pgAdminIII and Report Manager (using ODBC) the recordset returns a complete date and time as expected. This leads me to suspect the RB supplied driver. If I leave the field names the same and the exact same SQL statement but change the field type to either only date or only time, it returns just what is expected also. Any help would be appreciated. Rocky Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
