Sybase date functions

Thread View: comp.sys.next.programmer

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by William Swats Fri, 31 Jul 1992 13:22

#387

Author: William Swats
Date: Fri, 31 Jul 1992 13:22

24 lines
1358 bytes

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.

The only thing I can find in the DB-Library is dbconvert() which only  
applies to converting data between datatypes and does not have as much  
functionality as I need.
--
Richard Maurer                          
Bryan, Pendleton, Swats & McAllister    Phone: 615-665-1640
P.O. Box 150949	                        Fax: 615-665-1650
Nashville, TN                           Internet: rmaurer@bpsm.com
(NeXTmail OK)                           UUCP: uunet!bpsm!rmaurer
-- 
William Swats                           NIC Handle: WS259
Bryan, Pendleton, Swats & McAllister    Phone: 615-665-1640
One Burton Hills Blvd., Suite 275       Fax: 615-665-1650
Nashville, TN                           Internet: wswats@bpsm.com

Re: Sybase date functions

#419

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads