I am have one date (string) field in the format 'dd-mmm-yy' like ('1-Jan-87'). Now I want to convert it as 'DD/MM/YYYY' like (01/01/1987).
Please help me in this conversion.
TO_DATE(Column_name, 'dd/mm/yyyy')
Use the above function to covert.
I am getting one data filed from one text file at format 'MM/DD/YY'(like '06/13/14'). Now I want to convert it as 'DD-MMM-YYYY' like (13-JUN-2014).
Items in dropdown 01/31 02/28 03/31 04/30 .........
12/31
How to print current date and time in C/C++, sample program will help?
I have a date field on an html form that users may leave blank. If they do leave it blank I want to write the date 01/01/1901 into the mysql table. How can I accomplish this and where in my .php script file should I put the code?