Re: SQL Function / Statement to convert to timestamp

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Brian,

Not sure if I'm understanding your problem correctly, but in DB2 there is a
TIMESTAMP function:

timestamp('2009-12-31',  '15.30.06')

Would return:
2009-12-31-15.30.06.000000

HTH,

Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Thu, Jan 20, 2011 at 10:17 AM, Brian Piotrowski <
bpiotrowski@xxxxxxxxxxxxxxx> wrote:

> Hi All,
>
> Does anyone happen to have an SQL function handy that will take separate
> date and time fields and convert them to a timestamp?  I have some web pages
> that need to access a specific date and time range (ie: 01/20/2011 06:00:00
> to 01/21/2011 02:00:00), and I'm having a bit of a time trying to get the
> system to return data when they are split in two separate fields.
>
> I'd love to convert the field to a timestamp, but it would involve a lot of
> recompiling of other programs.
>
> Thanks.
>
> /b;
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> Brian Piotrowski
> Assistant Mgr. - I.T.
> Simcoe Parts Service, Inc.
> Ph: 705-435-7814 x343
> Fx: 705-435-5029
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> http://www.simcoeparts.com
>
> Please consider the environment. Don't print this e-mail unless you really
> need to.
>
> The information contained in this communication is confidential and
> intended only for the use of those to whom it is addressed.  If you have
> received this communication in error, please notify me by telephone (collect
> if  necessary) and delete or destroy any copies of it.  Thank you!
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.