Complete answer: 1. Is there a function available in SQL? Yes, the SQL 92 spec, Oct 97, pg. 171, section 6.16 specifies this functions: CURRENT_TIME Time of day at moment of evaluation CURRENT_DATE Date at moment of evaluation CURRENT_TIMESTAMP Date & Time at moment of evaluation 2. It is implementation depended so each database has … Read more
OK, lets do this properly. Select dates matching today, using indexes if available, with all the different date/time types present. The principle here is the same in each case. We grab rows where the date column is on or after the most recent midnight (today’s date with time 00:00:00), and before the next midnight (tomorrow’s … Read more
SELECT CAST(GETDATE() AS DATE) Returns the current date with the time part removed. DATETIMEs are not “stored in the following format”. They are stored in a binary format. SELECT CAST(GETDATE() AS BINARY(8)) The display format in the question is independent of storage. Formatting into a particular display format should be done by your application.
If you’re looking at using this for relative timing (for example for games or animation) I’d rather use CACurrentMediaTime() double CurrentTime = CACurrentMediaTime(); Which is the recommended way; NSDate draws from the networked synch-clock and will occasionally hiccup when re-synching it against the network. It returns the current absolute time, in seconds. If you want … Read more