combine date and time fields

[junkjones]

Hi Everyone,

Is there a way to combine two fields in a query? I have a DATE field, and a TIME field. But in my SQL statement I want to say

select * from table
where DATE+TIME BETWEEN 'date+time' AND 'date+time'

can this be done? I know in other DB's you can just say TIMESTAMP(date, time) and it will combine them together, but I can't get that to work in MySQL.

Any help is very much appreciated!

 

[sleipnir214]

Happily, since MySQL stores dates in YYYY-MM-DD format, date order and alphabetical order are one and the same.

How 'bout:

WHERE concat(datefield, ' ', timefield) BETWEEN '<onedatetimestamp>' and '<anotherdatetimestamp>' Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[junkjones]

This did the trick! Thanks for your very fast response