time stamps/sql?

[l_evans]

Hi people,

got a question for time functions

I have a table where i need to store a time value which can be retrieved through PHP $time = time(......);

my question is how should I store it in mysql if i want to retrieve information later like:

select * from theTable where time "between november 15th 2001 and december 15th 2001" (i wasnt sure of the syntax so i wrote out in english).

If i store this as a varchar it would be hard to do queries like this on the mysql variable. anybody got any suggestions?

[kevinsequeira]

try searching the forum ... this post is on the same page

http://www.phpbuilder.com/board/showthread.php?threadid=10238675

reg
kevin

[Hatch]

If your going to be dealing with the date AND time then make your date column in your sql table to the DATETIME type. Then you can insert and retrieve dates and also be able to select ranges. It's kinda confusing learning it for the first time though 😛