From and to dates...

Anon

I was looking for help on how to view records from an access database (and MySQL) from and to a certain date?

The time stamp in the access database is
yyyy-mm-dd hh:mm:ss

I want a form that asks for a from and to date. like from [ dd mm yyyy ]
to [ dd mm yyyy ]

I'm using PHP 4.0 and have setup the ODBC link to the database.
Thanks

Anon

I remember having to specify date literals between # signs, but I found these, which are apparently the ODBC standards for date literals.

Date
use { d 'yyyy-mm-dd' }
e.g { d '1995-06-20' }

Time
use { t 'hh:mm:ss' }
e.g { t '15:34:08' }

Date/Time
use { ts 'yyyy-mm-dd hh:mm:ss' }
e.g { ts '1995-06-20 15:34:08' }

Anon

Thanks very much for your help !

Can I sort on the first few characters of the time stamp? i.e

$timestamp = '2000-12-30 01:01:01'

select from where $timestamp > $2000-12-30 order by $timestamp[1,10]

I'e just sort records by the date and not time as well? Thanks.

Martin Taylor wrote:

I remember having to specify date literals between # signs, but I found these, which are apparently the ODBC standards for date literals.

Date
use { d 'yyyy-mm-dd' }
e.g { d '1995-06-20' }

Time
use { t 'hh:mm:ss' }
e.g { t '15:34:08' }

Date/Time
use { ts 'yyyy-mm-dd hh:mm:ss' }
e.g { ts '1995-06-20 15:34:08' }

Anon

Sorry - I don't know!

But what does this give you? Sorting by date only, rather than including the time, will give you pretty much the same results, and (worse?) times within the same date will probably be sorted randomly.

Anon

In MySQL this is quite easy. Let's assume the following variable are set from a form or whatever:

$date1 = '2000-12-25';
$date2 = '2001-03-06';

Then you're MySQL statement to select everything between those two dates is:

SELECT * FROM your_table WHERE date_column BETWEEN '$date1' AND '$date2';

I bet you wish it was that easy in Access.

---John Holmes...