Converting dates to Padded SQL format

Sannyasin Sivakatirswami katir at hindu.org
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

into

04/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.

Thanks

Himalayan Academy Publications
Sannyasin Sivakatirswami
Editor's Assistant/Production Manager
katir at hindu.org
www.HinduismToday.com, www.HimalayanAcademy.com,
www.Gurudeva.org, www.hindu.org




More information about the use-livecode mailing list