Get the time portion of a date in SQL

by Andrew Jackson 11. July 2009 12: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

CodeChimp's Blog