PL/SQL 101 : DataTypes - DATE

BluShadow

A long awaited instalment of my PL/SQL 101 series, following on from the NUMBER datatype...

The topic for today is.... the DATE datatype...

Enjoy

[ Edited 08 Jan 2016 08:45 GMT+0 : Updated link to date functions on page 22 ]

Oracle_Monkey

Nice to put the information in the PDF .

Jagadekara

Thank you BluShadow..

2de09af8-b363-4e18-8213-de7999bf99af

Thanks for that, i have read the pdf until now and i'm learning interesting things.

Well made pdf, by the way.

Great work.

Amatu Allah Neveen Ebrahim

Thanks, pls keep it up with more advanced cases.

BluShadow

Thanks, pls keep it up with more advanced cases.

Any suggestions in particular?

Amatu Allah Neveen Ebrahim

Any suggestions in particular?

Yes, Date is really a Great Oracle datatype has date, time and time status (AM,PM).

Date counts in our Work Attendance (IN/OUT) working hours, exclude Holidays out of working hours, influence the employees excuses Many advanced date usage are required in approximately in a daily basis. Even the Overtime or the Delay has an increment or decrements in workers or employees working hours during the day,etc.

Lovely & Powerful essay u can conquer.

Amatu Allah.

Chizzle Pack

Thank you, excellent.

Frank Kulash

I especially like what it says at the top of page 14:

... we've seen some really ingenious (read that as "bad") code ...

ranit B

Hey Blu,

It is indeed very useful, and put up in a very concise manner. Thanks a lot!

Just one thing - from page 22 -

If you’re not familiar with the DateTime functions within Oracle, take some time to read through each of them and have a practice to really get a feel for what you can do. They’re all nicely documented:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions001.htm#i88891

Why is the documentation link of v10.2 ? Atleast v11.2 ? Any reason in particuar... Just curious!

BluShadow

Hey Blu,

It is indeed very useful, and put up in a very concise manner. Thanks a lot!

Just one thing - from page 22 -

If you’re not familiar with the DateTime functions within Oracle, take some time to read through each of them and have a practice to really get a feel for what you can do. They’re all nicely documented:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions001.htm#i88891

Why is the documentation link of v10.2 ? Atleast v11.2 ? Any reason in particuar... Just curious!

First link found when searching.  I'll update it when I have a moment.