Click here to Skip to main content
15,867,834 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have a column which has date-time,i want to convert that into hours and minutes/minutes only,any sql statement that can help me?

(NB still a learner)
Posted
Comments
gvprabu 13-May-13 7:02am    
u need to get only time part from ur Date time column Right
Puseletso Michelle 13-May-13 7:10am    
yes only time from datetime column correct @gvprabu

Hi,

Check the following Code
SQL
SELECT GETDATE()
GO
-- SQL Server 2000/2005
SELECT CONVERT(VARCHAR(8),GETDATE(),108) AS HourMinuteSecond,
CONVERT(VARCHAR(10),GETDATE(),101) AS DateOnly;
GO
-- SQL Server 2008 Onwards
SELECT CONVERT(TIME,GETDATE()) AS HourMinuteSeconds;
SELECT CONVERT(DATE,GETDATE()) AS DateOnly;
GO

Check the link
Get Date and Time From Current DateTime [^]

Regrds,
GVPrabu
 
Share this answer
 
Comments
Puseletso Michelle 13-May-13 7:09am    
Thanks but i don't want to get the current date, the date is already inserted in a column how do i convert that datetime?

thanks in advance
gvprabu 13-May-13 7:11am    
U can use the same logic for ur SELECT Statement. Check this and USe the logic where ever u need.
gvprabu 13-May-13 7:12am    
If that column is DATETIME Datatype. then use SELECT CONVERT(VARCHAR(8),Column_Name,108) AS HourMinuteSecond FROM Table_Name
Puseletso Michelle 13-May-13 7:14am    
Problem solved

Thanks so much....
gvprabu 13-May-13 7:14am    
In SQL Server 2008 we have TIME Data Type, So we can use CONVERT Statement like as Follows
SELECT CONVERT(TIME,Column_Name) AS HourMinuteSeconds FROM Table_Name
SELECT CONVERT(VARCHAR(8),GETDATE(),114) AS Hoursminuteseconds
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900