Datetime type is accurate to hours, minutes and seconds, how to remove minutes and seconds

33213321

Datetime type is accurate to hours, minutes and seconds, how to remove minutes and seconds

lj0917

select getdate ()

select convert (char (10), getdate (), 120)

fanfan1980

select convert (char (8), getdate (), 108)
--result
--------
22:46:56

(1 row (s) affected)


select convert (char (10), getdate (), 120)
--result
----------
2017-01-04

(1 row (s) affected)

unkmass

select convert (char (13), getdate (), 120)

unkmass

Do you want hours?

33213321

Hero, you explain what char (13) 120 means

unkmass

Convert the date to a character type, take the first 13 digits, 120 refers to the format at the time of conversion: yyyy-mm-dd hh: mm: ss [.fff]-[. Fff] refers to milliseconds

33213321

Thanks, hero, I get it, and ask another question
Regarding the money type, can you directly determine the number of decimal points when building a table, such as two decimal places

unkmass

Monetary data represents positive or negative monetary values. Use the money and smallmoney data types to store monetary data in SQL Server. The accuracy of monetary data storage is four decimal places.