AW: Best method using SQL to combine date fields (day, month, year)

Hi,

Hopefully some magical SQL command that I can use inline?

Unfortunately there is no magical command at all. Converting numeric date
values into real values with SQL is rather unhandy.

You need to convert the numeric values into a valid character representation
of a date, either 'YYYY-MM-DD' or 'MM/DD/YYYY' or 'DD.MM.YYYY'.
After the conversion you can use the SQL scalar function DATE() to convert
the character representation into a real date.
You may try the following (and perhaps creating an UDF).

Date(Digits(MyNumYear) concat '-' concat Digits(MyNumMonth) concat '-'
concat Digits(MyNumDay))

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"

-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von Bradley V. Stone
Gesendet: Monday, 20. October 2008 18:18
An: MIDRANGE-L@xxxxxxxxxxxx
Betreff: Best method using SQL to combine date fields (day, month, year)

Ok, building some dynamic SQL statements.

Got to a file that has date separated into year, month and day fields. Ugh.

So, wondering the best/easiest way to combine these so I can use them in an
SQL statement? Hopefully some magical SQL command that I can use inline?

Thanks!

Bradley V. Stone
BVSTools - www.bvstools.com
eRPG SDK - www.erpgsdk.com