how to limit create date or return first 50 records?

[#1]

Hi there,

I am novice and have 2 questions.

1.how to limit create date? script as below:

LOAD "ACCOUNTABILITY_ID",

    "ACTION_TYPE",

    "ADDNL_INFO",

    "CREATE_DATE";

SQL SELECT "ACCOUNTABILITY_ID",

    "ACTION_TYPE",

    "ADDNL_INFO",

    "CREATE_DATE"

FROM DBO."ACTIVITY_LOG_DM" where CREATE_DATE>='2014-04-01 00:00:00' and CREATE_DATE<'2014-04-02 00:00:00';

script error:

SQL##f - SqlState: S1000, ErrorCode: 1861, ErrorMsg: [Oracle][ODBC][Ora]ORA-01861: literal does not match format string

SQL SELECT "ACCOUNTABILITY_ID",

    "ACTION_TYPE",

    "ADDNL_INFO",

    "CREATE_DATE"

FROM DBO."ACTIVITY_LOG_DM" where CREATE_DATE>='2014-04-01 00:00:00' and CREATE_DATE<'2014-04-02 00:00:00'

2.how to return first 50 records?

thank you.

[its_anandrjs]

Try Like below script

LOAD "ACCOUNTABILITY_ID",

    "ACTION_TYPE",

    "ADDNL_INFO",

    "CREATE_DATE"

    where CREATE_DATE>='2014-04-01 00:00:00' and CREATE_DATE<'2014-04-02 00:00:00' and RowNo() <= 50;

SQL SELECT "ACCOUNTABILITY_ID",

    "ACTION_TYPE",

    "ADDNL_INFO",

    "CREATE_DATE"

FROM DBO."ACTIVITY_LOG_DM";

[#3]

LOAD "ACCOUNTABILITY_ID",

    "ACTION_TYPE",

    "ADDNL_INFO",

    "CREATE_DATE"

WHERE CREATE_DATE >= '2014-04-01 00:00:00' and CREATE_DATE < '2014-04-02 00:00:00';

SQL SELECT TOP 50

     "ACCOUNTABILITY_ID",

    "ACTION_TYPE",

    "ADDNL_INFO",

    "CREATE_DATE"

FROM DBO."ACTIVITY_LOG_DM";

[its_anandrjs]

One of the other way is put First 50 key word will give you to load first 50 records only put above the table load see the code below

First 50

LOAD "ACCOUNTABILITY_ID",

    "ACTION_TYPE",

    "ADDNL_INFO",

    "CREATE_DATE"

    where CREATE_DATE>='2014-04-01 00:00:00' and CREATE_DATE<'2014-04-02 00:00:00';

SQL SELECT "ACCOUNTABILITY_ID",

    "ACTION_TYPE",

    "ADDNL_INFO",

    "CREATE_DATE"

FROM DBO."ACTIVITY_LOG_DM";

Hope this helps