Al usar AWS re:Post, aceptas las AWS re:Post Términos de uso
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?

Temas
Análisis
Etiquetas
Amazon Athena
Idioma
English
lisannegesch
preguntada hace 2 años879 visualizaciones
1 Respuesta
0
Respuesta aceptada

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
respondido hace 2 años
  • lisannegesch
    hace 2 años

    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
    hace 2 años

    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!

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas

Contenido relevante