Select from Date and ToDate

Question

0.00/5 (No votes)

See more:

Hi I have a table with field InvoiceDate but its Datatype is in Varchar
I want to select a particular Time Period but it shows all the date apart from my selected Range

Posted 10-Mar-13 18:28pm

Bala4 . V

Updated 10-Mar-13 18:31pm

v2

Add a Solution

Comments

Garth J Lancaster 11-Mar-13 0:34am

Why dont you post the relevant code/SQL statement - thats the easisest way for someone to be able to help you - otherwiese we can only guess what you are trying to do

gvprabu 11-Mar-13 0:47am

Hi,
If you have any chance to change the Data type VARCHAR to DATETIME. Tel me one thing how you are validating the Stored Data is proper DATETIME?

Ankur^\m/ 11-Mar-13 1:16am

You have probably written a wrong query. Post your query here (Use 'Improve Question' widget to update your question) and we might help.

Aarti Meswania 11-Mar-13 1:16am

InvoiceDate column is varchar but in which format you have stored date?
e.g. dd-MM-yyyy hh:mm:ss tt
or yyyy-MM-dd...
or MM-dd-yyyy...

2 solutions

Solution 2

Hi,
You can also make use of substring.
The Substring function in SQL is used to grab a portion of the stored data

SELECT SUBSTRING(InvoiceDate, startingPosition, Endposition) FROM TableName

Posted 10-Mar-13 19:50pm

susanna.floora

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)

Santhosh Kumar Jayaraman · Accepted Answer · 2013-03-10T19:14:00

Solution 1

SQL

select convert(DATETIME, InvoiceDate , 103),* from Invoice 
where  convert(DATETIME, InvoiceDate , 103) between '2013-01-01' and '2013-1-30'

Posted 10-Mar-13 19:14pm

Santhosh Kumar Jayaraman