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 <ronnie.smith...@gmail.com>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
> <pandarik...@gmail.com> 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" <ronnie.smith...@gmail.com>
> 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
> > 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
> >
> > --
> > 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
>
>
>
> --
> 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
>
--
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
