Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3858
  • Last Modified:

Get Month and Year from date field...

How can I get the MONTH and YEAR from a Date field in an Interbase database  (I believe it's 7)
0
kevp75
Asked:
kevp75
1 Solution
 
NickUpsonCommented:
select extract(month from datefield) from mytable

or within an SP

mymonth =  extract(month from datefield);
0
 
kevp75Author Commented:
DOH...

figured it out, just before you posted that :)

points off to you :)  thanks!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now