Hi everybody ,
I am new to Pervasive SQL , can anybody help me out which site should I learn more from the beginning to higher level.
and the simple and complex queries used in pervasive .
Thanks , have a nice weekend !!
I have to update the values of a table where if the year is 1-9 then add zero before the number and if its >= 10 then don't add zero .
so what query be written for this in pervasive
select ( dateC + (select case when len(datey) = 1 then
'0' else '' end + datey as datey1 ) + '/' +...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.