[thelist] SQL, MS Access - ORDER BY date

jon steele jjsteele22 at yahoo.com
Fri Jun 29 20:48:36 CDT 2001


Hi everyone,

I was wondering what the technique was to order records from a database
by date? I need to to order the records returned to a query through
mysql. Here are some questions I had:

1) If the field type is date, and I have 'ORDER BY
field_which_has_a_date_type' will it order it correctly...or does it
matter what the format of the date is?

2) What is the standard format of entering dates into an MS Access
database from an coldfusion/asp

3) Is it possible to store the date in any format (e.g. 29/6/2001 9:35,
or June 29,2001 9:35, etc. etc.) and use a Convert to timestamp
function on it? Or does the format of the date matter? I was wondering
if I could convert the dates in the db to a timestamp number of use
that to sort it.

An ideas are welcome.

Thank You,
Jon.

__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/




More information about the thelist mailing list