2. getdate() uses the specified timestamp
3, getdate() to get the current date
Attached, Correspondence between return values of getdate() function Key Value secondsSeconds minutes Minutes hours Hours mday Day of the month wday Day of the week, numeric (Sunday is 0, Saturday is 6) mon Month, numeric year year, numeric (4 digits) yday Day of the year, numeric (e.g., 299) weekday Day of the week, textual, full (e.g., "Friday") month Month, textual, full (e.g., "January") 0 Seconds since epoch (what time( ) returns) |