Re: Sybase date conversion

[Clara Carter <clarac@RAINMAKERSYSTEMS.COM>]

Thanks a bunch everyone.
This online manual is great too for future questions I know we will come
accross.

Clara

At 02:25 PM 10/27/99 -0400, you wrote:
>        Clara ,
>
>        The sybase manuals are online on the web and accessible through
>their web page.
>        If the below link works you should be the SQL Reference Manual.
>Chapter 4 contains the
>date functions.   I think datepart will help you  use the month to group by.
>Reading through
>the date functions should help you decide which is appropriate though.
>
>
>http://sybooks.sybase.com:80/onlinebooks/group-as/srg1100e/sqlref/@Generic__
>BookView;cs=default;ts=default
><http://sybooks.sybase.com:80/onlinebooks/group-as/srg1100e/sqlref/@Generic
_>_BookView;cs=default;ts=default>
>
>
>        Hope this helps.
>        Huey
>
>
>                -----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