perhaps datepart, as in
DATEPART(m,datefield) where m is the code in SQL Server to give the month number.
SQL Server came from Sybase, so maybe this will work for you.
Bob
-----Original Message-----
From: Clara Carter [mailto:clarac@RAINMAKERSYSTEMS.COM]
Sent: Wednesday, October 27, 1999 12:57 PM
To: Multiple recipients of list SQR-USERS
Subject: Sybase date conversion
Hi,
Does anyone know how to get the month only from a date field in Sybase.
We need to group by the month. We use informix and our new phone data
is in sybase and we have no manuals.
Thanks
Clara