Converting dates to Padded SQL format

Sannyasin Sivakatirswami katir at
Sun Oct 27 12:56:10 EST 2002

What is the most direct way to get from the long date (minus the day) 
to the fully padded RPT scripting language SQL format.

We want  to convert

April 15, 1998



This doesn't seem doable in a single convert operation in xTalk
I an need to compare records in a text database with a postGre
Sql data base records where the date field in one is

text record field: April 4, 2001

and the other is

SQL field: 04/04/2001

Of course I can write a function to parse the long date and build the 
SQL formatted padded date with the long year... but, was hoping there 
was as more direct function. i don't see the long date return edin any 
numeric date format....could be missing something.


Himalayan Academy Publications
Sannyasin Sivakatirswami
Editor's Assistant/Production Manager
katir at,,,

More information about the use-livecode mailing list