Converting dates to Padded SQL format
Sannyasin Sivakatirswami
katir at hindu.org
Sun Oct 27 12:56:01 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 metacard
mailing list