Operations on Date/timestamp in Oracle

Set the session format for date in Oracle to ' YYYY-MM-DD HH24:MI:SS '

Alter session set Nls_date_format= ' yyyy-mm-dd hh24:mi:ss ';

Set the session format for timestamp in Oracle to ' YYYY-MM-DD hh24.mi.ss.ff '

Alter session set Nls_timestamp_format= ' yyyy-mm-dd hh24.mi.ss.ff ';

Inserting date into Oracle in C # allows you to manipulate dates data directly:

SELECT * from T_table WHERE createdate between ' 2015-09-15 ' and ' 2015-09-25 '

The operations timestamp in C # must be indirectly timestamp to Oracle:

SELECT * from T_table WHERE createdate between to_timestamp (' 2015-09-15 ', ' yyyy-mm-dd hh24:mi:ss ') and to_ TIMESTAMP (' 2015-09-25 ', ' yyyy-mm-dd hh24:mi:ss ')

Or

SELECT * from T_table WHERE createdate between to_timestamp_tz (' 2013-12-09 ', ' Yyyy-mm-dd HH24:MI:SS. FF tzh:tzm ') and To_timestamp_tz (' 2015-12-09 ', ' Yyyy-mm-dd HH24:MI:SS. FF Tzh:tzm ')

Operations on Date/timestamp in Oracle