In ms_ SQL, time is converted to year, month, day, hour, and second.

The SQL statement is as follows:

Select Year = year (getdate (), month = month (getdate (), Day = Day (getdate ())
, Hour = datepart (hour, getdate ())
, Minute = datepart (minute, getdate ())
, Second = datepart (second, getdate ())

 

Concatenate the system time into the year, month, day, hour, minute, and second.

Select cast (Year (getdate () as varchar (10) + 'Year' + Cast (month (getdate ())
As varchar (10) + 'month' + Cast (Day (getdate () as varchar (10) + 'day' + Cast (datepart (hour, getdate ()) as varchar (10) + 'time'
+ Cast (datepart (minute, getdate () as varchar (10) + 'shard'

Note: Cast functions are used for conversion. Usage: If the CASET () as type (length) is int, the length is not required ..

For example, select cast ('1, 2, 3 'as money) as INT.

 

If you only need time, use

Select convert (varchar (20), getdate (), 120) as date