I am reading from a MS Access database and want to convert the date
returned in a select statement. Without the conversion, the date looks
like this when printed:
01954-03-25 00:00:00
$requests = "SELECT
person_name,
sex_code,
Age,
DOB,
#to_char(DOB, 'YYYYMMDD'),
Citizen_Country_Code,
Birth_Country_Code
from REGISTRATION_REQUESTS";
The commented out line is what I would do in Oracle to get what I want.
I haven't been able to accomplish the same. This may not be a DBI
question but help would be appreciated.
Regards,
Dennis M. Gray
Canberra: +61-2-6258-7917
Sydney: +61-2-9310-7907
Fax: +61-2-9310-7917
Mobile: +61-418-646267
