Re: Sybase date conversion

["htreadwell(contr-comp)" <htreadwell@SNAP.ORG>]

        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