Working with DateTime?

[matt-]

Hi all,

Im using PHP5 with MySQL, and have created a table with a DateTime field.

Firstly, how do i insert the current date/time into it?

INSERT INTO MyTable (RegistrationDate) VALUES (NOW()) ?

Secondly, how can I then query the table, and check between two date ranges, e.g.

SELECT Blarp, Blarp2 FROM MyTable WHERE Registration IS AFTER StartDate AND Registration IS BEFORE EndDate

I've checked the documentation and can't find any good examples, any help please?

Thanks,
Matt.

[matt-]

I should probably add that the StartDate and EndDate filters are optional, so it needs to work if one of them isn't there.

Thanks,
Matt.

[r937]

yes, use NOW() for current datetime

as for the range test, change

... WHERE Registration IS AFTER StartDate AND Registration IS BEFORE EndDate

to

... WHERE Registration >= StartDate AND Registration <= EndDate

[matt-]

Thanks very much rudy, hadn't realised it was that simple!