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
