In the last episode (Mar 18), Mahmoud Badreddine said:
> Hello,
> I have a table with separate integer values for the day, month and year.
> I would like to group them all under one field of type date.
> I tried a few commands but I haven't captured the right syntax yet.
>
> so if the field names are dayVal,monthVal and YearVal in talbeDummy
>
> I am doing the following
> select str_to_date(DayVal.MonthVal.YearVal,'%d.%m.%Y') from tableDummy;
CONCAT(DayVal, ".", MonthVal, ".", YearVal)
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
