Jump to content


Photo

ORDER BY DATE/TIME


  • Please log in to reply
3 replies to this topic

#1 essjay_d12

essjay_d12
  • Members
  • PipPipPip
  • Advanced Member
  • 121 posts

Posted 13 March 2006 - 10:49 AM

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.

#2 webwiese

webwiese
  • New Members
  • Pip
  • Newbie
  • 9 posts

Posted 13 March 2006 - 11:09 AM

Hi,

just use the SQL - DATETIME field.



#3 essjay_d12

essjay_d12
  • Members
  • PipPipPip
  • Advanced Member
  • 121 posts

Posted 13 March 2006 - 12:15 PM

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

#4 webwiese

webwiese
  • New Members
  • Pip
  • Newbie
  • 9 posts

Posted 13 March 2006 - 12:17 PM

oh, I'm sorry, I've read your article too fast ....




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users