Skip to main content
Question

Date Field

  • August 15, 2024
  • 1 reply
  • 3 views

douglas.souza
Level 4
Forum|alt.badge.img+3

Can anyone help me with this problem, I'm not able to convert this date field in this format to SQL. Does anyone know if I can get this in PQL? Or even in SQL

 

08-JUL-24

1 reply

rita.kiss12
Level 7
Forum|alt.badge.img+3
  • Level 7
  • August 20, 2024

The right date format in PQL is {d '2024-07-08'}

But it's not very clear for me what you are trying to do.

Do you try to convert this in Data Pool Transformations? Or PQL Editor?

What's the data type of the column where this is stored?