Oracle Timestamp

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’