Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

SYNTAX_ERROR: line 6:19: Unexpected parameters (timestamp, integer, integer) for function substr. Expected: substr(varchar(x), bigint, bigint)

0

SELECT distinct substr(ORDER_DATE,1,10) mm, pzd.PART_KEY part_key FROM PZDTORBK PZD WHERE PZD.ORDER_DATE > TO_DATE ('2021-01-01','YYYY-MM-DD') --AND (substr(PO_NUMBER,5,1) <> 'L' and substr(PO_NUMBER,-2,2) <> '02') --group by to_char(PZD.ORDER_DATE,'MON'

Topics
Migration & Modernization
Tags
AWS Database Migration Service
Language
English

asked 4 years ago568 views

1 Answer
0

Hi,

The first input parameter for the substr function should be a varchar/char. Have you tried CASTing it? For example:

select substr(cast(column_name as varchar(column_length)), 1,10) ...

Thanks,

AWS
EXPERT

answered 4 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content