Jump to content

Archived

This topic is now archived and is closed to further replies.

essjay_d12

ORDER BY DATE/TIME

Recommended Posts

I need to order the table results by the Date and if its the same Date then the most recent time.

There is a DATETIME function , but I was wondering is it possible to get the System Date and time and insert it some how (Rather than the user inserting it).

If not what would be the best way of solving this?

Thanks

D.

Share this post


Link to post
Share on other sites
Yeah I have done that, but I wanted a syste, date ...

I found it ... using NOW() seems to insert the current date and time of the system.

Thanks

D

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.