|
Hi all,
I have one table containing data
as "source.txt" attached file. I want to create a script to clean the data
and get the result as "result.txt" attached file.
inbtime and inbtime1 is datetime data type. Anyone has an idea?
Any help will be
appreciated.
thanks in advance
Sorry. It seems to be out of the
topic.
Regards,
lonh
|
card inbtime inbtime1 ---------------- --------------------------- --------------------------- 0250002 2002-01-25 19:16:41.000 2002-01-25 19:17:18.000 0250002 2002-01-25 19:17:18.000 2002-01-25 20:12:07.000 0250002 2002-01-25 20:12:07.000 2002-01-26 05:34:09.000 0250002 2002-01-26 05:34:09.000 2002-01-27 18:38:52.000 0250002 2002-01-27 18:38:52.000 2002-01-27 18:38:52.000 0250003 2002-01-25 06:28:31.000 2002-01-25 17:13:26.000 0250003 2002-01-25 17:13:26.000 2002-01-26 06:39:00.000
card inbtime ---------------- --------------------------- 0250002 2002-01-25 19:16:41.000 0250002 2002-01-25 19:17:18.000 0250002 2002-01-25 20:12:07.000 0250002 2002-01-26 05:34:09.000 0250002 2002-01-27 18:38:52.000 0250003 2002-01-25 06:28:31.000 0250003 2002-01-25 17:13:26.000
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
