Perl, Date format with Foxpro

Date format with Foxpro

Author	Message
Ysteric' #1 / 3	Date format with Foxpro hi all, i'm using DBD::XBase to access DBF files. In a table i have a 'date' field, and, in a "select" query i want it to return only the year and month...something like this : Select distinct to_char(TheDate, 'YYYYMM') from Planning; ( works with Oracle...) is there anybody to give me the rigth syntax ? or is the DBD::XBase unable to do this ? Thanks everybody Eric
Sat, 01 Dec 2001 03:00:00 GMT

Jonathan Stow #2 / 3	Date format with Foxpro Quote: > hi all, > i'm using DBD::XBase to access DBF files. > In a table i have a 'date' field, and, in a "select" query i want it to > return only the year and month...something like this : > Select distinct to_char(TheDate, 'YYYYMM') from Planning; ( works with > Oracle...) > is there anybody to give me the rigth syntax ? or is the DBD::XBase unable > to do this ? I doubt if you can do this straigntforwardly - you will need to get the date out in whatever format it comes as and then manipulate it later. /J\ -- "Pat was wondering if he could put his massive tool in my box" - Mrs Doyle, Father Ted
Sat, 01 Dec 2001 03:00:00 GMT

Jonathan Stow #3 / 3	Date format with Foxpro Quote: >> hi all, >> i'm using DBD::XBase to access DBF files. >> In a table i have a 'date' field, and, in a "select" query i want it to >> return only the year and month...something like this : >> Select distinct to_char(TheDate, 'YYYYMM') from Planning; ( works with >> Oracle...) >> is there anybody to give me the rigth syntax ? or is the DBD::XBase unable >> to do this ? > I doubt if you can do this straigntforwardly - you will need to get the > date out in whatever format it comes as and then manipulate it later. This is also mentioned in the XBase FAQ : <http://www.fi.muni.cz/~adelton/perl/man3/XBase::FAQ.html> /J\ -- "William Hague, the world's favourite hairline" - Rory Bremner
Sat, 01 Dec 2001 03:00:00 GMT

Page 1 of 1

[ 3 post ]