Re: help with datetime query

Posted in 2010

Cesar Inacio Martins — Tue, 30 Mar 2010 07:26:12 -0700 (PDT) — source: Usenet: comp.databases.informix

Use the TO_DATE() function. http://publib.boulder.ibm.com/infocenter/idshelp/v115/topic/com.ibm.sqls.doc/ids_sqs_1543.htm#ids_sqs_1543 --- Em ter, 30/3/10, Floyd Wellershaus <floyd@fwellers.com> escreveu: De: Floyd Wellershaus <floyd@fwellers.com> Assunto: help with datetime query Para: informix-list@iiug.org Data: Terça-feira, 30 de Março de 2010, 9:18 I have a timestamp in a log in this format: YYYYMMDDHHMMSS eg ..20100329123000 I think there is a way to do this but can't figure it out. what I want to do is compare the time in the log with the current time and be able to determine if the time from the log is an hour old or more. Thanks ! Floyd -----Anexo incorporado----- _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list ____________________________________________________________________________________ Veja quais são os assuntos do momento no Yahoo! +Buscados http://br.maisbuscados.yahoo.com