topic Re: Substring SQL in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/substring-sql/m-p/3705192#M892164 <HTML><HEAD></HEAD><BODY><P>There is no such function found...</P><P>Can u check and revert.</P></BODY></HTML> Wed, 16 Apr 2008 05:37:01 GMT Former Member 2008-04-16T05:37:01Z Substring SQL https://community.sap.com/t5/application-development-and-automation-discussions/substring-sql/m-p/3705190#M892162 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have a table which has a field DATETIME. YYYYMMDDhhmmss format.</P><P>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.)</P></BODY></HTML> Wed, 16 Apr 2008 05:25:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/substring-sql/m-p/3705190#M892162 Former Member 2008-04-16T05:25:00Z Re: Substring SQL https://community.sap.com/t5/application-development-and-automation-discussions/substring-sql/m-p/3705191#M892163 <HTML><HEAD></HEAD><BODY><P>ABI_TIMESTAMP_CONVERT_INTO.this will convert your date to time stamp.and with the derived time stamp get your range.</P><P></P><P>This will convert the datestamp to date and time.</P><P></P><P>for example.</P><P>1.1.2007 and 12/2007 is converted to date stamp and fetched</P></BODY></HTML> Wed, 16 Apr 2008 05:33:03 GMT https://community.sap.com/t5/application-development-and-automation-discussions/substring-sql/m-p/3705191#M892163 former_member210123 2008-04-16T05:33:03Z Re: Substring SQL https://community.sap.com/t5/application-development-and-automation-discussions/substring-sql/m-p/3705192#M892164 <HTML><HEAD></HEAD><BODY><P>There is no such function found...</P><P>Can u check and revert.</P></BODY></HTML> Wed, 16 Apr 2008 05:37:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/substring-sql/m-p/3705192#M892164 Former Member 2008-04-16T05:37:01Z