Format date in pervasive 1

[shmilyca]

Hi,
I dont knoiw lot about pervasive ..is there any function readily available that can format date display from 20060816 to 08/16/2006 format?

 

[mirtheil]

What version of PSQL are you using? There's no ready made function but if you are using PSQL V.9x, you can create a function that does it. You'd need to use functions like "Left", "Right", and "Substring" to convert it.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[shmilyca]

ok.. I am using Pervasive 8. Thank you very much for your help.

 

[shmilyca]

Well..I build query using substring to show format i wanted..it works in control center. but when i use odbc driver (Data direct 5.0) it fails saying unknow syntax substring. any idea? . I am using pervasive sql 8.0. I could use left & right but I need substring to get month right?

 

[mirtheil]

I don't know if the Data Direct driver supports substring. Why not use the PSQL ODBC Driver.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[shmilyca]

Where can I get more inofrmation on psql odbc driver? I have no idea why they are using datadirect driver since I am new to this project. How can I switch to psql odbc driver? what are advantages/disadvantages of using psql odbc driver?

 

[mirtheil]

The PSQL driver is included with the PSQL engine. It's called "Pervasive ODBC Engine Interface" or "Pervasive ODBC Client Interface". You would change your Data Source Name to use the PSQL driver rather than the Data Direct driver.
The advantages are that it's directly tied to the PSQL engine and was written by Pervasive where the Data Direct driver is an add on.


Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician

http://www.mirtheil.com

 

[shmilyca]

ok thank you. Apprciate your help.