حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

How to format date in MySql

siddu

siddu

SOLVED CLOSED ACTIVE ANSWERED
User: siddu
Posted: on Jun 27, 2014 03:18 AM
Forum: MySQL
Answer: 1
Views: 5486

hi

SELECT NOW()

out put

2008-11-11 12:45:34

but i want mysql date function work as

SELECT NOW()

out put :11-11-2008 12:45:34

Download FREE API for Word, Excel and PDF in ASP.Net

Azim

Azim

0 1

Reply
ANSWER
User: Azim
Replied: on Jun 27, 2014 03:20 AM
Report

Refer this

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

SQL Fiddle

http://sqlfiddle.com/#!2/f9208/2

http://stackoverflow.com/questions/1861489/converting-a-date-in-mysql-from-string-field

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Contact Us

Email: webmaster@aspsnippets.com
Address:
ASPSNIPPETS PRIVATE LIMITED
G-110, SHAGUN ARCADE,
MALAD (EAST),
MUMBAI, MAHARASHTRA,
INDIA 400097.

© COPYRIGHT 2026 ASPSnippets.com ALL RIGHTS RESERVED.