is there a function in SQL where you can get current time and date, and use it somehow :
is there a function in SQL where you can get current time and date, and use it somehow :
select * from table where currentDate-anotherDate = result
select * from table where currentDate-anotherDate = result
which db?
ReplyDeleteaccess
ReplyDeletecan't help on that :-(
ReplyDeleteThanks anyway! :)
ReplyDeleteCURRENT_TIMESTAMP is standard ANSI SQL, so should be portable across various SQL databases. If using SQL Server, you may find this reference page handy. http://msdn.microsoft.com/en-us/library/ms186724.aspx
ReplyDeletewith Access, standards go out of the windows, usually :-) but you might be lucky :-)
ReplyDeleteMaybe. http://office.microsoft.com/en-us/access-help/use-current-date-and-time-in-calculations-HP001098479.aspx?CTT=5&origin=HA001054662
ReplyDeleteIn Access, try the Now() function to get the current date and time, and the Date() function to get the date. Sort of like the Delphi equivalents.
ReplyDeleteKyle Miller Phillip Woon Thanks, it works
ReplyDelete