> > > I posted this last week but didn't get a single reply. I > thought someone could at least give me a clue about where to look.
How about google. With a little work (10 minutes), I found: Format([Date of Birth],"dddd mmmm d ") AS [formatted date] Which would give me a clue that I could change the format specifier to a few different things and then, also, look on msdn.microsoft.com for more information about Access and Format function... Regards, Jeff > > Using DBD::ODBC with MS Access 97 (not my choice but that's > where the data is). The database has date_of_birth in a > date/time field with YYYY-MM-DD as the Access display format. > My select statement looks something like this: > > $dbquery = "SELECT > date_of_birth > from REGISTRATION_REQUESTS > "; > > If I then fetch and print the results, the date_of_birth, > without any formatting comes out like 01942-10-29 00:00:00. I > have yet been able to find a means of converting the date. > With the DBD::Oracle, I could just include a tocharacter > function and specify a conversion mask. > > I know this is really an Access question and not specifically > a DBI one but I am hoping to find someone in the group who > might know the answer. I can user Perl functions to substring > the date into the format I want but would like to know if > there is a different solution. > > Regards, > > Dennis >
