SQL statement problem
From: Calvin <calvin_at_isidasia.com.hk>
Date: Wed, 29 Aug 2001 14:23:03 +0800
Message-ID: <9mi1kv$qbd$1_at_news.hk.linkage.net>
Date: Wed, 29 Aug 2001 14:23:03 +0800
Message-ID: <9mi1kv$qbd$1_at_news.hk.linkage.net>
Dear all,
I am a student but have some problem about the assignment !
I hope someone can ans me !!!
I have the date field in table,
now I want select the department start in 1997.
how to write SQL statement in specify the Year is ??
Thanks
eg. department depdate
admin l1-JUN-90
purchasing 06-AUG-97
development 12-Sept-97
Calvin
Received on Wed Aug 29 2001 - 08:23:03 CEST