OQL datetime value

0
Hello,   When assigning date time value in OQL using 'AS', it is not working when I provided as below. Can someone help on this? admin.userdetail.name AS District, admin.userdetail.name AS Zone, ''2022-10-05'' AS duedate FROM admin.userdetail Thanks
asked
2 answers
0

Hey,

 

I think you can do it by just removing the 'AS' and just inserting the name you want after the entity.

 

 

Best,

Miguel Sabugueiro

answered
0

Use the OQL-function Cast, like this:

admin.userdetail.name AS District,
admin.userdetail.name AS Zone,
CAST ('2022-10-05' AS DateTime) AS duedate
FROM admin.userdetail

 

answered