Re: Sybase date functions

Article View: comp.sys.next.programmer

Article #419

Back to comp.sys.next.programmer Previous Next

#419

From: Chris Toczycki
Date: Mon, 03 Aug 1992 14:00

29 lines
1068 bytes

In article <1992Jul31.132231.1239@bpsm> wswats@bpsm.com (William Swats) writes:
> Hi;
> 
> From within a program, I want to access Sybase database functions to  
> manipulate DBDATETIME's (Sybase date/time variables) in a similar manner  
> to the isql functions 
>    datepart
>    datediff
>    dateadd   
> particularly - datepart and datediff.
> 


You can use the Sybase server to do the conversion by sending it a command.

E.g

	select 
		datepart(month, '5/30/92 15:06:02')

	OR

	select
		datediff(month,'5/30/92','4/30/90')

You'll have to dbbind and dbnextrow to get the results (or whatever method you  
currently use).

chris@fnbc.com

Technical Details

Message-ID: <1992Aug3.140015.4088@fnbc.com>

Path: arc1-ca.pugleaf.net!sparky!uunet!psinntp!juliet!news

References: <1992Jul31.132231.1239@bpsm>

Show Full Headers

Complete Article Headers

Newsgroups: comp.sys.next.programmer
Path: arc1-ca.pugleaf.net!sparky!uunet!psinntp!juliet!news
From: chris@fnbc.com (Chris Toczycki)
Subject: Re: Sybase date functions
Message-ID: <1992Aug3.140015.4088@fnbc.com>
Sender: news@fnbc.com
Organization: First National Bank Of Chicago, Chicago IL, USA
References: <1992Jul31.132231.1239@bpsm>
Distribution: na
Date: Mon, 3 Aug 92 14:00:15 GMT
Lines: 29

Reply to Parent Message