Many times when working with date and times in select, where – the data doesn’t show up in the result window or is not in the format we are looking for. SQL server provides with some build in functions to format the date and time string for you.
When using date time the most common function used are
- Getdate() – this provide the server current date/time.
- Getutcdate() – this provides the universal date/time.
For converting date time into date/time formats we can use the convert function or the format function