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'))
Monday, December 1, 2008
Subscribe to:
Post Comments (Atom)
6 comments:
Thank you :)
This really helped me !
Deepa
WOW just what I was searching for. Came here by searching for cheap conference calling
Have a look at my blog post :: bancuri rusesti
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
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
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
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
Post a Comment