DATES Handling in FIREBIRD 1.5

[GosPHEL]

Hi there All!


I was trying to Benchmark a Stored Procedure 'cause it sent me recordset in very different times, So I tried to Get a

TIEMPO_INICIAL= CAST(CURRENT_TIMESTAMP AS TIMESTAMP);

CODE CODE CODE
CODE CODE CODE
CODE CODE CODE
CODE CODE CODE
CODE CODE CODE
CODE CODE CODE


TIEMPO_FINAL= CAST(CURRENT_TIMESTAMP AS TIMESTAMP);

When I tried to do this:

TIEMPO_RESULTANTE = (TIEMPO_FINAL) - (TIEMPO_INICIAL);

It sends me an error:

CONVERSION ERROR FROM STRING 0.0000000
....

Where could I find Dates Handling documentation?

Am I wrong?

I aprecciate!


Noe Monreal
Just Going Up!

http://noe.com.mx

 

[MartijnTonies]

Hi,

You don't have to cast CURRENT_TIMESTAMP to the "TIMESTAMP" datatype, it's already of that type.

What type is TIEMPO_RESULTANTE?

Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird, MySQL & MS SQL Server

http://www.upscene.com

 

[MartijnTonies]

PS: There is a special Firebird forum at this website.