Improve company productivity with a Business Account.Sign Up

Status: Solved
Priority: Medium
Security: Public
Views: 370
Last Modified: 2013-02-08

Query Date/Time field

I need to query a table where I am looking at a time stamp. The time stamp that i will be looking for will be for the month of January 2013.

The dates in the time stamp will be formatted like this (Date/Time):

1/1/2013 2:00:00 PM
1/3/2013 4:00:00 PM
1/17/2013 8:00:00 PM

How do I query this field so that I only get the month of January and the year of 2013.

Thanks.

donnie91910

Asked: 2013-01-02

Advertise Here

Query Syntax

6 Solutions

LVL 39

Pratima PharandeCommented: 2013-01-02

which database you are using ?

SQL server

Select Month(date_col) , Year(date_col)

LVL 39

Pratima PharandeCommented: 2013-01-02

Oracle / PL SQL

SELECT EXTRACT(month FROM date_col) from table_name

LVL 39

Pratima PharandeCommented: 2013-01-02

Oracle / PL SQL

SELECT EXTRACT(month FROM date_col) , EXTRACT(year from date_col) from table_name

LVL 39

Pratima PharandeCommented: 2013-01-02

mysql

Select Month(date_col) , Year(date_col)

donnie91910Author Commented: 2013-01-02

Microsoft Access 2003 database .

LVL 39

Pratima PharandeCommented: 2013-01-02

same
Select Month(date_col) , Year(date_col)
http://www.techonthenet.com/access/functions/date/month.php

LVL 29

IrogSintaCommented: 2013-01-02

How about:
Select Format(date_col, "mmmm yyyy")

That will give you January 2013

mmm will give you Jan

mm will give you 01

donnie91910Author Commented: 2013-01-02

There are other dates also:

1/1/2013 2:00:00 PM
1/3/2013 4:00:00 PM
1/17/2013 8:00:00 PM
2/11/2009 4:00:00 PM
4/21/2010 6:00:00 PM
6/21/2005 1:00:00 PM

I only want to query for the January 2013 dates.

LVL 39

Pratima PharandeCommented: 2013-01-02

you mean to say you want all sates for JAn 2013 , does not want formatting
try this

Select date_col from tablename

where Month(date_col) = 1 and Year(date_col) = 2013

santoshsahoo123Commented: 2013-01-02

select * from table where Month ( coloumn name ) =01 and year (coloumn name) =2013

Check and update if it s working.

LVL 29

IrogSintaCommented: 2013-01-02

Select Format(date_col, "mmmm yyyy") From NameOfTable Where Format(date_col,"yyyy mm") = "2013 01"

LVL 5

jaiminpsoniCommented: 2013-01-03

select to_char(<date_col>, 'mm/dd/yyyy hh:mi:ss AM') from <NameOfTable> where to_char(<date_col>, 'mmyyyy') = '012013';

LVL 50

PaulCommented: 2013-02-01

[[date-field] between [low-date] and [high-date]

see: http://www.youtube.com/watch?v=TFXzGdTSfTg

note, generally in sql: "between ... and ..." is the equivalent of:

[date-field] >= [low-date] and [date-field] <= [high-date]

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Expand your skills with this month's free Premium course.

Query Date/Time field

Join & Write a Comment Already a member? Login.

Featured Post