SQL Language (MOSC)

MOSC Banner

Record inserted within a time period

edited Jul 2, 2015 10:02AM in SQL Language (MOSC) 8 commentsAnswered

Hi,

I've a table bat_inf as below.

I need to get a record( select ba_id, BA_DTTM   from bot_inf   where     BA_ST_STG_DTTM (starting time )   is within last 15 hrs),


please help with this sql....   thanks ...........                 

Name                                      Null?    Type

----------------------------------------- -------- ----------------------------

BA_ID                                  NOT NULL NUMBER

BA_APP_INFO                            VARCHAR2(50)

BA_DTTM                                   TIMESTAMP(6)

BA_ST_STG_DTTM                    TIMESTAMP(6)

BA_END_STG_DTTM                 TIMESTAMP(6)

BA_END_TGT_DTTM                 TIMESTAMP(6)

BA_ST                                       VARCHAR2(20)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center