Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 4 of 4 total |
EncodeDate, EncodeTime? |
Sat, Jan 21 2012 12:46 PM | Permanent Link |
Lucian | Hi,
What's the SQL equivalent for X := EncodeDate(Year, Month, Day) + EncodeTime(Hour, Minute, Second, MSec); TIA, Lucian |
Sat, Jan 21 2012 1:34 PM | Permanent Link |
Fernando Dias Team Elevate | Lucian,
CAST( CAST(Year AS VARCHAR) + '-' + CAST(Month AS VARCHAR) + '-' + CAST(Day AS VARCHAR) + ' ' + CAST(Hour AS VARCHAR) + ':' + CAST(Minute AS VARCHAR) + ':' + CAST(Second AS VARCHAR) + '.' + CAST(MSec AS VARCHAR) AS TIMESTAMP) -- Fernando Dias [Team Elevate] Em 21-01-2012 17:46, Lucian escreveu: > Hi, > > What's the SQL equivalent for > X := EncodeDate(Year, Month, Day) + EncodeTime(Hour, Minute, Second, MSec); > > TIA, > Lucian > |
Sat, Jan 21 2012 2:40 PM | Permanent Link |
Lucian | Thanks a lot
Lucian |
Sun, Jan 22 2012 3:09 AM | Permanent Link |
Uli Becker | Lucian,
in addition to Fernando's post: you can easily create your own function. If you want to use integers e.g.: CREATE FUNCTION "EncodeDate" (IN "FYear" INTEGER, IN "FMonth" INTEGER, IN "FDay" INTEGER) RETURNS DATE BEGIN RETURN CAST( CAST(FYear as VARCHAR) + '-' + CAST(FMonth as VARCHAR) + '-' + CAST (FDay as VARCHAR) AS DATE); END Regards Uli |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |