[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Sybase date conversion

Clara,

if u store your date in $tring variable, then use
Substr to get the month.

HTH,
Manoj


>From: Clara Carter <clarac@RAINMAKERSYSTEMS.COM>
>Reply-To: SQR-USERS@list.iex.net
>To: Multiple recipients of list SQR-USERS <SQR-USERS@list.iex.net>
>Subject: Sybase date conversion
>Date: Wed, 27 Oct 1999 09:57:20 -0700
>
>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

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com