i want some query in SQL

Question

1.00/5 (1 vote)

See more:

hi to all,
how to write query for date format in sql,Here i already write ms access query

for date

(Format('{0}', 'dd/mm/yyyy'),

. Now same think i want to write in sql

query. and datatype is datetime in sql.

Posted 12-Feb-15 23:13pm

JOTHI KUMAR Member 10918227

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rajesh waran · Answer 1 · 2015-02-12T23:18:00

Solution 1

You may refer here,
https://www.google.co.in/?gfe_rd=cr&ei=bc7dVO7vJJDV8gfbsIGADw&gws_rd=ssl#q=datetime+format+in+sql[^]

Few ex here:
http://www.w3schools.com/sql/sql_dates.asp[^]
http://www.w3schools.com/sql/func_convert.asp[^]

Posted 12-Feb-15 23:18pm

Rajesh waran

Updated 12-Feb-15 23:29pm

v3

Comments

JOTHI KUMAR Member 10918227 13-Feb-15 5:22am

here i asked in mccess we put (Format('{0}', 'dd/mm/yyyy') like that but in sql how to put format for datetime.

Rajesh waran 13-Feb-15 5:23am

In Sql you may try Convert().

JOTHI KUMAR Member 10918227 13-Feb-15 5:24am

yes because in database type should be in datatime

JOTHI KUMAR Member 10918227 13-Feb-15 5:38am

i have to write this dateformat in insert query. my database type is in datetime format

**Zoltán Zörgő** · Answer 2 · 2015-02-12T23:18:00

Solution 2

1) Supposing you mean SQL Server. You can use CONVERT[^]. From SQL Server 2012 you have FORMAT[^] also.
2) Don't do that. If you have any presentation layer above the data access layer, better do formatting there.

Posted 12-Feb-15 23:18pm

Zoltán Zörgő

Comments

JOTHI KUMAR Member 10918227 13-Feb-15 5:22am

here i asked in mccess we put (Format('{0}', 'dd/mm/yyyy') like that but in sql how to put format for datetime.

Zoltán Zörgő 13-Feb-15 5:25am

Not clear. Pleas specify which RDBMS you have!

JOTHI KUMAR Member 10918227 13-Feb-15 5:29am

here i have datatype for date is DataTime in database. Now how i write query for this format in SQL .

JOTHI KUMAR Member 10918227 13-Feb-15 5:31am

i have to write this dateformat in insert query. my database type is in datetime format

Zoltán Zörgő 13-Feb-15 7:04am

I asked, which RDBMS you are using: MS Access, MS SQL Server, MySQL, PostgreSQL, Oracle, Firebird,....?

JOTHI KUMAR Member 10918227 13-Feb-15 7:25am

SQL SERVER 2008

Zoltán Zörgő 13-Feb-15 7:26am

Great. Than what is the problem with CONVERT? Format number 103 will give you dd/mm/yyyy. Have you tried it? But note, that it will yield varchar!

Maciej Los · Answer 3 · 2015-02-12T23:58:00

Solution 3

Date is a date, does not need to be formated!

If your sql server uses different than end-user date format, use SET DATEFORMAT[^] command.

Posted 12-Feb-15 23:58pm

Maciej Los

MohamedEliyas · Answer 4 · 2015-02-27T00:58:00

Solution 4

Delphi

insert into table1(approvaldate)values(18-06-12 10:34:09 AM);

Posted 27-Feb-15 0:58am

MohamedEliyas

Comments

CHill60 27-Feb-15 8:29am

Reasons for my vote of 1:
- the question is a couple of weeks old and already resolved
- your SQL is incorrect - it results in the error "Msg 102 : Incorrect syntax near '10'."
- Even if you surround your date and time with single quotes you will still get the error "Msg 242: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value."
- If you changed it to insert into table1(approvaldate)values('18-JUN-12 10:34:09 AM'); then it would work but the OP would be stuck with a date of your choosing.