date format

[master_student]

I need to load data from qvd where creation date < 28/05/2018 and store the result in an other qvd

heres the result of my QVD :

here is my script :

load *

FROM

(qvd)

where CREATION_DATE <'28/05/2018';

the result is :

I don't know why the format of my data fiels date création change? ANY HELP pleaase ??

[olivierrobin]

hello

date is stored under this format

before the comma the date

after the comma, the hour

you have to use date() or date#() functions to format it

[master_student]

can you explain more please. i need my date and time field

[Anil_Babu_Samineni]

Can you attach sample QVD to test? I've not got this kind of issue

[master_student]

done.

[kfoudhaily]

or just change the date format option in the propreties.