Substring SQL

[Former Member]

Hi

I have a table which has a field DATETIME. YYYYMMDDhhmmss format.

I want to extract only those records whose date is between 01 - 2007 and 12 - 2007. ( Actually it wont be static but for reference i have provided this.)

[Former Member]

There is no such function found...

Can u check and revert.

[former_member210123]

ABI_TIMESTAMP_CONVERT_INTO.this will convert your date to time stamp.and with the derived time stamp get your range.

This will convert the datestamp to date and time.

for example.

1.1.2007 and 12/2007 is converted to date stamp and fetched

[Former Member]

There is no such function found...

Can u check and revert.