syntax for SQL Read system time

--Get the current date (for example: YYYYMMDD)

Select CONVERT (nvarchar), GETDATE (), 112)

--Get the current date (for example: YYYYMMDD hh:MM:ss)
Select GETDATE ()

--Get the current date (for example: YYYY-MM-DD)
Select Datename (Year,getdate ()) + '-' +datename (Month,getdate ()) + '-' +datename (Day,getdate ())

--Get the current date (for example: YYYY/MM/DD)
Select Datename (Year,getdate ()) + '/' +datename (Month,getdate ()) + '/' +datename (Day,getdate ())

--Get several dates
Select Datename (Year,getdate ())-year (YYYY)
Select Datename (Yy,getdate ())

Select Datename (Mm,getdate ())--month
Select Datename (Dd,getdate ())--date
Select Datename (Hh,getdate ())--Get hours
Select Datename (Mi,getdate ())--Get minutes
Select Datename (Second,getdate ())--Get seconds
Select Datename (Week,getdate ())--Gets the current week (week) is the first week of the Year (week)
Select Datename (Weekday,getdate ())--Days of the week

syntax for SQL read system time (RPM)