How to get Time from DateTime in SQL Server

Question

hiI have table in database that have Time column with datatype time7now I want put recent time in this columnfor date I use GetDate but for time what should I useBest RegardsNeda

dharmendr · Accepted Answer

Hi nedashBelow is the querySELECT CONVERTVARCHAR7GETDATE108 Time

dharmendr · Answer

Hi  nedashSince your datatype is Time its showing by adding 00 with the inserted value Cant do any thing for this Only way is you can chage the datatype to VARCHAR to insert only hour and minDECLARE Test AS TABLET VARCHAR5INSERT INTO Test VALUESCONVERTVARCHAR5GETDATE108SELECT  FROM Test  T1347

How to get Time from DateTime in SQL Server

Company

Explore

Follow us

Contact Us