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 <michaeljmo...@gmail.com> 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 <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
--
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
