time() function

[shamsuljewel]

Hi guys..I am using time function to insert a data to the table

INSERT INTO table(name,insert_date) Values('$name','time()')

so when I want to search a specific name on specific date by mysql query how should I do it?

coz time() function insert 01022332 like this valu how should I search a date suppose 2008-01-21 entries?

 

[Nhoj]

"SELECT * FROM `table` WHERE `time` > UNIX_TIMESTAMP('2008-01-21 12:00:00');"

 

 

[laffin]

that depends on your SQL creation for that field

 

but it wud be easier if ur SQL was in date or datetime format. which makes building the query much easier than working with time() formats. use now() instead in the query and either date or datetime in the creation of yer table fields.

[shamsuljewel]

Yes I know date function is much more easier to handle.

thanks laffin and Nhoj.