I’m lazy and keep forgetting the format string for formatting dates into strings that I can understand, so here it is:
Function:
to_char()
Arguments:
1) The date column you want to format
2) The mask – personal most commonly used:
‘yyyy/mm/dd hh:mi:ss am’