Where Clause Julian date

Posted on 2014-08-25
Last Modified: 2014-11-16
Can someone tell me who to write a where clause for a jullian date

select * from table where juliandatefield = today's date

also is there a way to convert the date from Julian date to month day year in the where clause
Question by:MPDenver
    LVL 23

    Assisted Solution

    SQL> select to_date(2456143,'J') from dual;
    LVL 76

    Accepted Solution

    If juliandatefield is a varchar2:
    select * from table where juliandatefield = to_char( sysdate, 'j' );

    If a number:
    select * from table where juliandatefield = to_number(to_char( sysdate, 'j' ));
    LVL 76

    Assisted Solution

    by:slightwv (䄆 Netminder)
    It is all about the format mask when going from string/numbers to dates and back.

    I would check the online docs for what is allowed in the formatting:
    LVL 22

    Expert Comment

    by:Steve Wales
    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now