Monday, December 1, 2008

Canonical Date Function

passing character from parameter - fnd_standard_date

select fnd_date.canonical_to_date('2008/01/12') from dual;

alternate solution :

lv_start_date := TRUNC(TO_DATE(p_start_date,'YYYY/MM/DD HH24:MI:SS'))

6 comments:

Anonymous said...

Thank you :)
This really helped me !

Deepa

Anonymous said...

WOW just what I was searching for. Came here by searching for cheap conference calling

Have a look at my blog post :: bancuri rusesti

Anonymous said...

Hi there colleagues, pleasant post and pleasant arguments commented
at this place, I am truly enjoying by these.

Here is my blog :: bancuri fara prostii

Anonymous said...

Why visitors still use to read news papers when in this technological globe the whole
thing is accessible on net?

Also visit my page :: jocuri copii noi

Anonymous said...

This design is incredible! You certainly know how to keep a reader
entertained. Between your wit and your videos, I was almost moved to start my own blog
(well, almost...HaHa!) Great job. I really
enjoyed what you had to say, and more than that,
how you presented it. Too cool!

my webpage :: Juegos Online

Anonymous said...

Pretty nice post. I just stumbled upon your weblog and wanted to mention that I've really loved surfing around your blog posts. After all I'll be subscribing for your rss feed and I
hope you write once more very soon!

my weblog Juegos