Requrement for Date Format (dd/MM/yyyy)

Question

0.00/5 (No votes)

See more:

Hi !
A.I am using Date Format (dd/MM/yyyy) so store in DataBase in String Format.Because DateFormat of Database is (MM/dd/yyyy),can I change into (dd/MM/yyyy).
B.I am using GetDate() in SQL query, it require DateTime format.So how can I use it for string format of Date stored in Database.

Code is : In this Code FM_BankAC_Entry.Date is DateTime Format.I Require similar quiry for String Format.

SQL

SELECT     dbo.FM_BankAC_Entry.TransCode,dbo.FM_BankAC_Entry.TDate, dbo.FM_BankAC_Entry.TDetails, dbo.FM_BankAC_Entry.ChequeNo, dbo.FM_BankAC_Entry.AmtWithdr,FM_BankAC_Entry.AmtDep

FROM  FM_BankAC_Entry
where  FM_BankAC_Entry.Date between GETDATE()- @date1 and GETDATE()- @date2
        order by FM_BankAC_Entry.Date desc

Posted 17-Aug-10 2:36am

LebneizTech

Add a Solution

3 solutions

Solution 1

What do you mean?
If your field is in DateTime format then database does not store it in format. It just a date. It only shows depending on your regional setting.

But if you want to convert the date into any Varchar format then try Convert in SQL server. or take a look at System.Globalization.CultureInfo in VB.

Posted 17-Aug-10 2:45am

Goutam Patra

Solution 3

Thanks

I got the Tips for this Question.

Posted 18-Aug-10 0:22am

LebneizTech

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)

saanj · Accepted Answer · 2010-08-17T02:48:00

First of all this is not a SQL forum and you should move this to the proper place for more answers and faster responses.

For any sql date functions, the date has to be in the proper format (MM/dd/yyyy) format. You should not store the date in string format in sql if you want to do date time comparison. Though by type casting you can convert a string value into a datetime one but here the date format is wrong. However, you can use the following expression:

SELECT CONVERT(datetime, @date1 , 103)