I am needing some guidance on manipulating a date field.

I am working on creating a view and in this view I have a date field
in the format of 12/1/2009 9:40:49 AM.  I am needing to convert this
field to a integer and then add 36163 and return the results in this
field on my view.  I have been trying to google some info and don't
seem to be having any luck with it.  Anyone have any suggestions that
might help me with this? It probably is something simple that I am
overlooking since it is Friday and the weekend is almost here.

Thanks!

-- 
Ronnie D Smith Jr
IT Department
Rose Acre Farms
Phone (812) 497-2557 ext 290
rsm...@goodegg.com

-- 
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en

Reply via email to