This I am trying from 1 month, Front end I am using VB 6 and backend sql server 2000.I am inserting data into the date field using format(fild name,”dd/mm/yyyy”) command but still in backend it is storing as mm/dd/yyyy. It is still interesting to learn about learn about this new syntax. This keywords is very less used as CONVERT and CAST can do much more than this command.The SET DATEFORMAT command lets you specify order of data parts.The options for DATEFORMAT are mdy, dmy, ymd, ydm, myd, or dym. This commands allows to INSERT/UPDATE dates with different formats without doing any special data conversions.Print it out, write all over it, post your favorite lessons all over your wall!
how it can be possible,pls provide solution……………Hi Pinal, I have a query regarding datetime inputs to SQL SERVER.
CREATE TABLE #temp Table (Date Format Sample SMALLDATETIME) SET DATEFORMAT MDY INSERT INTO #temp Table VALUES ('09/28/2007') SET DATEFORMAT YDM INSERT INTO #temp Table VALUES ('2007/28/09') SET DATEFORMAT YMD INSERT INTO #temp Table VALUES ('2007/08/28') SELECT Date Format Sample FROM #temp Table DROP TABLE #temp Table dear Dave,i have problem displaying date format say 09/18/2008 using ms sql 2005 in java netbean ?
i use static String sel Holiday = “SELECT CONVERT(VARCHAR(10), Holiday, 101) AS [MM/DD/YYYY], Description from OFFDAY order by Holiday”; but still in java doesnot display the correct date formatregards, Halim SHi Dave,could you please advise me on how to bulk insert data into sql table from a text file which has second column in date format ‘YYYY-MM-DD’.
The date function always formats a timestamp, whether you supply one or not. The letters that PHP uses to represent parts of date and time will automatically be converted by PHP.
However, other characters like a slash "/" can be inserted between the letters to add additional formatting. Be sure to test this out on your own PHP enabled server, it's really great to see the instant results available with PHP date!
Submit a bug or feature For further API reference and developer documentation, see Java SE Documentation.