Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Date

Author  Topic 

evotin
Starting Member

2 Posts

Posted - 2007-04-25 : 02:50:22
How do i extract a particular value from a date field?
for example, 11-jan-2007
how do i extract the year out so that i can do a simple query to list things i want on that year?

using Oracle 9i

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-04-25 : 03:17:50
quote:
using Oracle 9i

I can only advice you based on MS SQL Server. FYI, this is a MS SQL Server forum.



KH

Go to Top of Page
   

- Advertisement -