Re: To split date column into day, month and year in SQL

Hello,

Using Windev 22, HFSQL 22

When I try to run the below query in WDSQL ( against HFSQL Classic files)

SELECT a.accountnamefk, a.voucherdate, DateToString(a.voucherdate, 'DD/MM/YYYY')
FROM gl_transaction_detail a

I get the following error:

In this version, the stored procedures are not supported in HFSQL Classic or HFSQL Mobile.
Error detected:
a.accountnamefk, a.voucherdate, >>>>DateToString(a.voucherdate, 'DD/MM/YYYY')<<<<<


How to split a date value stored in a file into day, month, year in HFSQL query ?

Happiness Always
BKR Sivaprakash

Hi,

you should use WL to indicate you want to use a WLanguage functions in SQL queries

SELECT a.accountnamefk, a.voucherdate, WL.DateToString(a.voucherdate, 'DD/MM/YYYY')
FROM gl_transaction_detail a

more info here...
[doc.windev.com]

Arie

Thanks Arie.