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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL - Current Year

Status
Not open for further replies.
Jonny1409

Jonny1409

Technical User
Jan 15, 2006
6
GB
Hello,

I'm trying to write a function which will give me, among other things, the current year.

I'm brand new to SQL so don't really know how to use functions properly yet, although from my VB knowledge, the structure looks very similar.

I've tried SELECT GETDATE() but it gives me an error about getdate not being valid inside a function.

How can I get this to work please ?

Cheers,
J.
 
Sort by date Sort by votes
you will have a much better chance of getting this question answered in forum183, the microsoft sql server forum

r937.com | rudy.ca
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BobThornton
  • Locked
  • Question
windows command in a sql script
Replies
1
Views
139
carp
carp
jchewsmith
  • Locked
  • Question
SQL Syntax 1
Replies
1
Views
109
JarlH
JarlH
soushi01
  • Locked
  • Question
Display only certain year data [SYSDATE] 1
Replies
2
Views
85
PHV
PHV
soushi01
  • Locked
  • Question
Nested For Loop update statement (pl/sql) 1
Replies
2
Views
113
soushi01
soushi01
jm89
  • Locked
  • Question
Does this function follow ansi sql standard? 1
Replies
4
Views
119
JarlH
JarlH

Part and Inventory Search

Sponsor

Back
Top