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:
Make an eye-catching cartoon video in five minutes with our free, easy-to-use online cartoon software.
You’re fighting for your customer’s attention on a crowded stage. The only way to get noticed is to be awesome and a little bit different — but how?
Make a sleek cartoon video. With our free online app you can make a stunning video in less time than it takes to drink a coffee.
Wait — aren’t your customers sophisticated grown-ups? Why should you even consider a cartoon video? Is animation still in? (Yes — but more on that later.)
A cartoon video transcends reality. It pulls us away from the scary real world and into a magical place where problems are solved by robots, bears, and other cute stuff you’ll never admit to liking in front of your friends.
It’s the perfect video format for:
Introducing playful, quirky businesses with personality and something to say Crafting cool looking ads for your latest social media campaign Educators and educational content creators who want to present information in a way that’s easy to digest Making training videos that don’t put the viewer to sleep Crossing cultural barriers (because everyone loves cartoons)
Ready to see what the fuss is about? Get started with one of our cartoon video templates below.
Biteable is ridiculously fun to use and keeps getting better. Really useful content too.
How to make a cartoon video.
Ready to make an awesome cartoon video of your own? Follow these super-simple steps.