month

Ales Hotko

Delphi Developer

Mon, 28 Jul 2003 04:41:27 GMT

month

hi,

how can i make query something like this

select * from some_table where month(input_date)=january

(to get data by month)

TIA,
Ales

M.H. Avegaar

Delphi Developer

Mon, 28 Jul 2003 17:06:47 GMT

Re:month

Use:

SELECT *
FROM some_table
WHERE EXTRACT(MONTH FROM input_date) = 1

"Ales Hotko" <ales.ho...@uni-mb.si> schreef in bericht
news:3A81B2F7.9CC2C1E1@uni-mb.si...

Quote

> hi,

> how can i make query something like this

> select * from some_table where month(input_date)=january

> (to get data by month)

> TIA,
> Ales

Andrew Bluet

Delphi Developer

Mon, 28 Jul 2003 18:05:23 GMT

Re:month

Ales,

It is the same as what you already have but replace the month wording with
corresponding number. IE. january = 1, february = 2, etc.

I hope this helps,
Andy

Quote

Ales Hotko <ales.ho...@uni-mb.si> wrote in message

news:3A81B2F7.9CC2C1E1@uni-mb.si...

Quote

> hi,

> how can i make query something like this

> select * from some_table where month(input_date)=january

> (to get data by month)

> TIA,
> Ales

Other Threads

1. Group by Month and Fill in Blank Months??

2. Comparison of Month-Length Algorithms

3. $$FREE TO START - $000s PER MONTH $$

4. years,months,days betwen tow dates

5. Grouping by a month part of a date field

6. SQL Statement month grouping

7. $50,000 per month - LEGAL

8. Make 300% profit or double your money in a month vGLFCbBJ

9. Make 300% profit or double your money in a month DHGwJCEw

10. Make 300% profit or double your money in a month FMAWDSGE