Pauldohert Something in here Local time Today, 14:32 Joined Apr 6, 2004 Messages 2,101 Feb 1, 2007 #1 This should be easy but I can't seem to do it - how do I format a datetime so I just see the hh:nn Ta
This should be easy but I can't seem to do it - how do I format a datetime so I just see the hh:nn Ta
Ron_dK Cool bop aficionado Local time Today, 23:32 Joined Sep 5, 2002 Messages 2,141 Feb 1, 2007 #2 Set your format to "Short Time " . Would that help ? Sorry in SQL : DATEPART(portion, Hh:Mi) Last edited: Feb 1, 2007
Pauldohert Something in here Local time Today, 14:32 Joined Apr 6, 2004 Messages 2,101 Feb 1, 2007 #3 Sorry didn't get that, DatePart(hh,@Date) gives me the hours DATEPART(portion, Hh:Mi) ???? Cheers
Ron_dK Cool bop aficionado Local time Today, 23:32 Joined Sep 5, 2002 Messages 2,141 Feb 6, 2007 #4 Would this work : DatePart(mi,n,@Date)
SQL_Hell SQL Server DBA Local time Today, 22:32 Joined Dec 4, 2003 Messages 1,361 Feb 6, 2007 #5 select cast(DatePart(hh,getdate())as varchar) + ':' + cast(DatePart(mi,getdate())as varchar)