Via Cà Matta 2 - Peschiera Borromeo (MI)
+39 02 00704272
info@synaptica.info

Tag: to_char

Oracle Tip – TO_DATE & TO_CHAR

In Oracle there are two usefull function to format a timestamp to string and vceversa…. To format a date to string you can use TO_CHAR function like this:

For viceversa To format a string to date you can use TO_ function like this:

The format mask list: Parameter Explanation YEAR Year, spelled out…
Leggi tutto