Two Dates Different values retrive

Guys. His query is of MYSQL. See the DEFINER Keyword.

Did you tried using STR_TO_DATE. You may follow more at below SO link.

http://stackoverflow.com/questions/10637581/mysql-date-format-dd-mm-yyyy-select-query

If this helps to address the issue, please close the thread by accepting the answer.

0

Hi,

You can use the British/French Format in Sql.

Reference :

https://dzone.com/articles/custom-date-formatting-sql-ser

http://www.w3schools.com/sql/func_convert.asp

0

try this :

1 .String.Format("{0:dd/MM/yyyy}", DateTime.Now) 26/07/2012

 2. String.Format("{0:MM/dd/yyyy}", DateTime.Now)  07/26/2012

 3 . String.Format("{0:dd/MM/yy}", DateTime.Now)  26/09/12

4. String.Format("{0:t}", DateTime.Now)  10:30 AM

 5.String.Format("{0:F}", DateTime.Now) Saturday, July 26, 2012 10:36:25 AM

http://www.codeproject.com/Questions/428390/How-to-get-date-from-server-in-mm-dd-yyyy-format

0