-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

http://members.fortunecity.com/polarissoft/Products/rFunc/rfunc.html

But just the way from date -> char

You may ask the author to add the opposite way (check the sourceforge project "rfunc", the author is currently creating a new version)

HTH

Michael

- -----Original Message-----
From: clementdoss [mailto:cdoss@...]
Sent: Montag, 18. August 2003 14:28
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Working with dates output / input blues (server side)


Hi all,

Everytime I have to work with date/datetime with FB I get into troubles. There are lots of different date layouts, and I need to import/export them. For example. I have a TXT file that have a date format like : YYYYMMDD (more common). But I got also YYMMDD , DD.MM.YYYY, DD/MM/YYYY , MM/YYYY, MMYYYY, ... , etc..

Is there a UDF function to help convert CHAR -> DATE and DATE -> CHAR? Something like:
CONVERTDate2TXT( Expression , Layout )
ConvertDate2Txt( now , 'YYYYMMDD') would output 20030818. and
ConvertTXT2Date( Expression , Layout )
ConvertTXT2Date( '20030818' , 'YYYMMDD') would output 18/08/2003 (date format)

Is there a function (or UDF) that already does this?
If there's isn't, would somebody help me write it?

Best regards,
Clément



- ------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark Printer at Myinks.com. Free s/h on orders $50 or more to the US & Canada. http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/67folB/TM
- ---------------------------------------------------------------------~->

To unsubscribe from this group, send an email to: firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/


-----BEGIN PGP SIGNATURE-----
Version: PGP 8.0

iQA/AwUBP0DPP+Haa+PgJ6iLEQJpcgCdGNpuznQ8peDHF0G0ENrvpuum9XgAnjo8
mgNQ3x0+r//Pme5XAFA72s4N
=3o1V
-----END PGP SIGNATURE-----