All is good now. Thanks for the quick help!!! Have a great weekend. Ronnie
On Fri, Dec 3, 2010 at 12:38 PM, Michael Moore <[email protected]> wrote: > select > to_char(to_date('12/01/2009','mm/dd/yy'),'J')-2378850 > from dual; > ??? > Mike > On Fri, Dec 3, 2010 at 9:14 AM, Ronnie Smith <[email protected]> > wrote: >> >> That is the right idea, but it is not returning the correct julian for >> us. This one returns 2455167 for the date I posted and we should be >> seeing 76,317. >> >> Thanks! >> >> On Fri, Dec 3, 2010 at 11:53 AM, Gopakumar Pandarikkal >> <[email protected]> wrote: >> > You mean converting to julian date format? >> > To_number(to_char("1-jan-10","J")) >> > Hope this helps >> > >> > regards >> > Gopa >> > >> > On Dec 3, 2010 9:42 PM, "Ronnie Smith" <[email protected]> >> > wrote: >> > >> > 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 >> > [email protected] >> > >> > -- >> > You received this message because you are subscribed to the Google >> > Groups "Oracle PL/SQL" group. >> > To post to this group, send email to [email protected] >> > To unsubscribe from this group, send email to >> > [email protected] >> > For more options, visit this group at >> > http://groups.google.com/group/Oracle-PLSQL?hl=en >> > >> > -- >> > You received this message because you are subscribed to the Google >> > Groups "Oracle PL/SQL" group. >> > To post to this group, send email to [email protected] >> > To unsubscribe from this group, send email to >> > [email protected] >> > For more options, visit this group at >> > http://groups.google.com/group/Oracle-PLSQL?hl=en >> >> >> >> -- >> Ronnie D Smith Jr >> IT Department >> Rose Acre Farms >> Phone (812) 497-2557 ext 290 >> [email protected] >> >> -- >> You received this message because you are subscribed to the Google >> Groups "Oracle PL/SQL" group. >> To post to this group, send email to [email protected] >> To unsubscribe from this group, send email to >> [email protected] >> For more options, visit this group at >> http://groups.google.com/group/Oracle-PLSQL?hl=en > > -- > You received this message because you are subscribed to the Google > Groups "Oracle PL/SQL" group. > To post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/Oracle-PLSQL?hl=en -- Ronnie D Smith Jr IT Department Rose Acre Farms Phone (812) 497-2557 ext 290 [email protected] -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
