Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

date format

Status
Not open for further replies.
JJJ777

JJJ777

Programmer
Jun 5, 2002
33
MY
hi all...

is there any possibility in SQL command to select just the year from date format in database.
As we all know the format is 2002-02-24 in the database.

therefore is that any possibilitty to take for example just the year by SQL command instead of we use coding which is normal method.



tq in advance..
 
Sort by date Sort by votes
[tt]SELECT EXTRACT(YEAR FROM column) FROM table[/tt]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

MCP2000
  • Locked
  • Question
Show records NOT BETWEEN date/timestamps
Replies
2
Views
536
MCP2000
MCP2000
timfoster
  • Locked
  • Question
How do I find out the create date of a table?
Replies
0
Views
273
timfoster
timfoster
metaltree
  • Locked
  • Question
How to get date of creation of columns?
Replies
1
Views
242
stefanwagner
stefanwagner
gwinn7
  • Locked
  • Helpful tip
PL Function Checking for Valid Date
Replies
0
Views
227
gwinn7
gwinn7
olav78
  • Locked
  • Question
Sum of “sales” for each date in a timestamp column
Replies
2
Views
177
olav78
olav78

Part and Inventory Search

Sponsor

Back
Top