Oracle TO_TIMESTAMP Function смотреть онлайн

https://www.databasestar.com/oracle-to_timestamp/
The Oracle TO_TIMESTAMP function can be confusing, but we’ll explain it in this video.

This function allows you to convert a string value into a TIMESTAMP value.

A TIMESTAMP value is a type of DATE, but has a few components:
- A date, including day, month, and year
- A time, including hours, minutes, seconds, and fractional seconds

This is a useful data type because it allows you to store a time down to fractions of a second.

The syntax of the TO_TIMESTAMP function is:

TO_TIMESTAMP ( input_string [, format_mask] [, nls_param] )

The input_string parameter is the string you want to convert.
The format_mask is where you specify the format of the input_string parameter. This is so you can specify the input_string in a variety of formats, and just use this format_mask to indicate which format it is in.
The nls_param parameter is another optional parameter, and allows you to specify the returning language of the month and day names.

The default format will depend on the region you’re running your database in. In my example (using Oracle Express in Australia), the default format is ‘DD-MM-RRRR HH:MI:SS AM’.

For more information on the Oracle TO_TIMESTAMP function, including the SQL used in this video, read the related article here:
https://www.databasestar.com/oracle-to_timestamp/