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