Home Forums SQL Server 7,2000 Administration Select Datepart RE: Select Datepart
brendt hess
Hall of Fame
Points: 3256
More actions
June 19, 2006 at 3:28 pm
#644704
Perhaps, but the questioner specifically requested a method using DatePart. I use this when generating a YYYYMMDDHHNN strings, in preference to stripping formatting out of a CONVERTed datetime, because it is far more readable.