time() to getdate

[otuatail]

Probably a none starter this. But I store my date using the time() function in a 10 char text field. I was wondering if I could do an SQL where date is > yesterday but would need to convert the time into a usable form. Is this possible?

 

Desmond.

 

Reason why I did this is because I could not store the date in MySQL date field WITH hh:mm:ss

 

[Ken2k7]

Store it as a DATE field in format of YYYY-MM-DD

 

If you just store hh:mm:ss, how can you tell if that's tomorrow, today, yesterday or even last year?

[otuatail]

I was only giving an indication of the problem. I have tried storing a date.

If I have a date field and I store '2009/050/18 18:04:22'

I get it in the database as '2009/050/18

hh:mm:ss NOW missing.

 

is this ok?

 

 

CREATE TABLE users (

users_id int NOT NULL auto_increment,

name char(20),

InsertDate datetime,

PRIMARY KEY (users_id)

);

 

INSERT INTO users (name , InsertDate) VALUES ('David' , NOW() )

 

select * from users where InsertDate > '2009/05/01'

 

 

[fenway]

That's a wildly misformated date.

[otuatail]

That meaning?

[fenway]

SQL-99 date format is YYYY-MM-DD HH:MM:SS.