T-SQL: Date only, time only

Posts: 833
Comments: 691
Trackbacks: 1

<< Managing a Doomed Software Project | Home | T-SQL: Other datetime functions >>

T-SQL: Date only, time only: SELECT dateonly = CONVERT(CHAR(8),column,112) FROM table
SELECT timeonly = CONVERT(CHAR(8),column,8) FROM table; posted on Wednesday, January 18, 2006 11:35 AM

Comments

# re: T-SQL: Date only, time only: jdn; 11/28/2008 1:53 PM; Uh, even if you clean up the syntax and add the create function piece, etc. this doesn't work. Here's a sample output:

954660:16:25.870

Post Comment

Title *
Name *
Email
Url
Comment *: Remember Me?

Please add 3 and 5 and type the answer here:

Enter the code shown above:

Archives

Post Categories

Stuff

My Company
My Resume

clustrmaps