Sams Teach Yourself SQL in 24 Hours, Second Edition

Hour 12, "Understanding Dates and Time"

Quiz Answers

1:	From where is the system date and time normally derived?
A1:	The system date is derived from the current date and time of the operating system on the host machine.
2:	List the standard internal elements of a DATETIME value.
A2:	YEAR, MONTH, DAY, HOUR, MINUTE, and SECOND.
3:	What could be a major factor concerning the representation and comparison of date and time values if your company is an international organization?
A3:	The awareness of time zones may be a concern.
4:	Can a character string date value be compared to a date value defined as a valid DATETIME data type?
A4:	A DATETIME data type cannot be accurately compared to a date value defined as a character string. The character string must ...