1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
0
I believe you just need to replace the / with -.
I tried running the below statement with "13-12-2022" and "4-12-2022" . It works
select date_parse('4-12-2022', '%d-%m-%Y') as does_it_work
répondu il y a 2 ans
Contenus pertinents
- demandé il y a un an
- demandé il y a 7 mois
- demandé il y a un an
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 7 mois
That would've been very easy but unfortunately I still got an error. A different one this time: SYNTAX_ERROR: line 25:3: Unexpected parameters (varchar, varchar(8)) for function date_format. Expected: date_format(timestamp with time zone, varchar(x)) , date_format(timestamp, varchar(x)) This query ran against the "db_retail_datascientists" database, unless qualified by the query. Please post the error message on our forum or contact customer support with Query Id: cd450b06-454d-4cb4-9719-b5a01e63e375
I'm sorry, wrong error haha. This is the error which I got. But I think I can fix this: INVALID_FUNCTION_ARGUMENT: Invalid format: ""
Thank you!