Get the time portion of a date in SQL

by Andrew Jackson 11. July 2009 05:23

select cast(convert(varchar, getdate(), 108) as datetime)

Note: Code 108 returns the time portion of a date in the format hh:mm:ss

Be the first to rate this post

Tags:

Getting into Android development Well I decided on my smartphone platform and have bought into the whole Google world and gone with...SQL Command Visualizer for Visual Studio 2005I've finally got round to writing a visualizer I've been wanting for years, one that will give a dec...Speed up your development dayOne thing that seems to be a bit hidden to most developers is that opening files within Visual Studi...

Comments are closed

Custom Settings Providers and Portable applications/U3 Drives (1)
Pärmar wrote: Doing a little research. Your post helped me – tha… [More]
Getting into Android development (1)
Baltimore Cooling wrote: When is the next post comming on this topic. … [More]
New Printer (5)
infrared illuminators wrote: Hi nice site design Regards Cook [More]
Saving Settings (6)
white board wrote: I added your post to my college Report Regard… [More]
Large Text Properties and Reflector (1)
seattle divorce lawyer wrote: I posted your blog to my facebook group Regar… [More]
New Download - WaitCursor Snippets for Visual Studio 2005 (4)
Gucci Bags wrote: I added your post to my college Report Regard… [More]
Allowing HTML to be entered into text boxes on ASP.net (2)
Photo to Pop Art wrote: Wonder full writing skills you got mate. Rega… [More]
VB.net 2005 - Easy settings persistance (5)
dog stroller wrote: Wonder full writing skills you got mate. Rega… [More]
New Download - GUID Visualizer for Visual Studio 2005 (4)
snoozer bed wrote: Hi nice POst Regards Moore [More]
Lisbox, IntegralHeight property (2)
patio aluminum furniture wrote: Now this is hghly recommeded post for me. I will s… [More]

CodeChimp's Blog