AddTimeToDate

Wed, 01/07/2009 - 14:48 |  hdanzl
0
DROP ROUTINE IF EXISTS "AddTimeToDate";

CREATE FUNCTION AddTimeToDate
(date1 date,
time1 as Time)
RETURNS Timestamp
BEGIN
  return CAST(CAST(date1 AS DOUBLE PRECISION) + CAST(time1 AS DOUBLE PRECISION) AS TIMESTAMP)
END
Category: 
SQL Functions & Procedures
Current Version: 
1.00
Supported Products: 
NexusDB V2
NexusDB V3
Login or register to post comments |  Print this chapter |  Send to friend |  PDF version |  metadata Tags:
Home

Powered by Drupal and Drupal Theme created with Artisteer.