IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
Alan
Personal Account . . .
Alan
 (Inactive)
Brisbane Australia
Rank: Cadet 1st Year
Real Name:  Alan [Unspecified]
Joined: Jun 2002 (12 years ago)
Visits: 5
Member Points10
Primary Role:  Coder
Location:  -- USA
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Message Boards Activity

2 posts.
More...

Thread 2 of 2
Thread Starter or a Reply (but not last)  Group

Alan
Arrays in Interbase
Is there an open array type in Interbase where you don't have to declare a length in advance? eg int[], , Also is there a source of examples of how to use arrays in Interbase?
Posted to MB Topic: Interbase « DBA Board
12 years ago
Nothing New Since Your Last Visit
1559
Hits

DBA, Databases, & Data

Thread 1 of 2
Thread Starter or a Reply (but not last)  Group

Alan
Interbase
I am using an older version of Interbase (ie 5.1 I think). I would like to use it to manipulate both dates and times. I had a lot of trouble understanding the online manual., , Are there any examples of how to do this in a stored procedure? Also is there a TIME datatype in Interbase?, , Thanks for your help., , Alan
Posted to MB Topic: Interbase « DBA Board
12 years ago

Scott
I remember having this problem several years ago. The answer is somewhere in my ancient code archives., , , , First, in Versions 5x of InterBase (5.0 through 5.6) there is no [b]TIME[/b] data type., , , , What I remember is that the [b]DATE[/b] fields are stored as a floating point number, with the whole portion of the value representing the actual DATE, and the fractional portion representing the TIME., , , , So, I remember I played arou...
12 years ago
Nothing New Since Your Last Visit
1248
Hits

DBA, Databases, & Data
-
  Load Time=less than 1 second.
 
Print This
-
 
Have a question? Need our services? Contact us now.
--Mike Prestwood

Call: 916-726-5675

email: info@prestwood.com


-
 
Connect With Us...
PrestwoodBoards
Join Us!
Facebook
Like our page!!!
Twitter
Follow us!
LinkedIn
Join Group
YouTube
View channel.
Go ahead!   Use Us! Call: 916-726-5675 


©1995-2014 Prestwood IT Solutions.   [Security & Privacy]   Made in the U.S.A..   No H1-B.   No offshoring.