Durch die Nutzung von AWS re:Post stimmt du den AWS re:Post Nutzungsbedingungen
AWS re:Postre:Post

INVALID_FUNCTION_ARGUMENT: Invalid format: "13-12-2022" is malformed at "-12-2022"

0

Hi, I'm trying to convert a string into a date. The format from the string is 13-12-2022 (or for example 4-12-2022). I've used the follwing query:

, date_parse(Openingsdatum, '%d/%m/%Y')

In which Openingsdatum refers to the string colum of the dates. I figured out that the query uses tho format %m%d%y, so it switched. Could somebody explain why I'm getting this error?

Themen
Analysen
Tags
Amazon Athena
Sprache
English
lisannegesch
gefragt vor 2 Jahren879 Aufrufe
1 Antwort
0
Akzeptierte Antwort

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
profile pictureAWS
Ananth Tirumanur
beantwortet vor 2 Jahren
  • lisannegesch
    vor 2 Jahren

    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

  • lisannegesch
    vor 2 Jahren

    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!

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen

Relevanter Inhalt