Re: SQL statement problem
From: Steve Long <slong3_at_mediaone.net>
Date: Wed, 29 Aug 2001 07:14:37 GMT
Message-ID: <xD0j7.3975$1s1.17723_at_typhoon.jacksonville.mediaone.net>
Date: Wed, 29 Aug 2001 07:14:37 GMT
Message-ID: <xD0j7.3975$1s1.17723_at_typhoon.jacksonville.mediaone.net>
try the following algorithm:
(1) find a good SQL text (2) look in the index regarding date handling (3) review related pages (4) if you still have questions, contact your faculty member.
hth
"Calvin" <calvin_at_isidasia.com.hk> wrote in message
news: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,
> eg. department depdate
> admin l1-JUN-90
> purchasing 06-AUG-97
> development 12-Sept-97
>
> now I want select the department start in 1997.
> how to write SQL statement in specify the Year is ??
>
> Thanks
> Calvin
>
>
>
Received on Wed Aug 29 2001 - 09:14:37 CEST