Hi!
When I run this from the psql monitor:
SELECT SUBSTR(CURRENT_DATE - INTERVAL '1 MONTH',0,11);
it returns - 2003-04-06 which is the desired behaviour.
Inside a CGI/DBI script it returns:
Sun Apr 06
Anyone have any idea what is going on here!?
Thanks!
-----------------------------------------------------------------------
Thomas Good e-mail: tomg@sqlclinic.net
Programmer/Analyst phone: (+1) 718.818.5528
Residential Services fax: (+1) 718.818.5056
Behavioral Health Services, SVCMC-NY mobile: (+1) 917.282.7359
// Das ist die Kunst - wie man alles verhunzt.