You can use the to_char function to convert a date into a string.
The DatetoTime function converts a string into a time or date.
The TimetoDate function converts a numeric time value into a string.
The GetDate function returns the current date as an integer value.