List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:March 18 2005 7:31pm
Subject:Re: Converting Integer values to date type
View as plain text  
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
	dnelson@stripped
Thread
Converting Integer values to date typeMahmoud Badreddine18 Mar
  • Re: Converting Integer values to date typeDan Nelson18 Mar
    • Re: Converting Integer values to date typeMahmoud Badreddine18 Mar
      • Re: Converting Integer values to date typeMichael Stassen21 Mar