Member Avatar for Bhavini_2

Hi,

I am new with sql server. I want my date formate like dd-mm-yyyy.. but i could not able to do so.
please help me and give me proper syntex fro the same

  • 5 Contributors
  • 4 Replies
  • 298 Views
  • 2 Years Discussion Span
  • Latest Post Latest Post by anand9796
Member Avatar for AndrisP

MySQL:

select date_format(now(), '%d-%m-%Y');

PostgreSQL:

select to_char(now(), 'dd-mm-yyyy');

OracleSQL:

select to_char(sysdate, 'dd-mm-yyyy') from dual;

Clause from dual in Oracle is required, in MySQL is optional, in PG SQL not usable - raise error

Edited by AndrisP
Member Avatar for rubberman

Also, FWIW, the dual interface in OracleSQL is basically the internal structural tables where stuff like date/time settings (and other stuff) are stored. If you are talking about MS SQLServer, that is basically Sybase massively altered by Microsoft. You would need to read their documentation to determine how to do what you want.

Member Avatar for Purvi_1

I'm using SQL Server and used this function to get the format like dd-mm-yyyy.

select FORMAT(GETDATE(),'dd-MM-yyy')
Member Avatar for anand9796

@Bhavini_2

for sql:" SELECT FORMAT (getdate(), 'dd-MM-yyyy') " this syntex works!

Edited by anand9796
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.