Converting dates to Padded SQL format

[Sannyasin Sivakatirswami]

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
[EMAIL PROTECTED]
www.HinduismToday.com, www.HimalayanAcademy.com,
www.Gurudeva.org, www.hindu.org

_______________________________________________
use-revolution mailing list
[EMAIL PROTECTED]
http://lists.runrev.com/mailman/listinfo/use-revolution