the problem of fastload the data about time

Tools

the problem of fastload the data about time

i define the time data like 2006-7-25 16:58:18 as timestamp(0) or timestamp(1),
but it doesn't work,the data can't load.

i also want to kown the differences between timestamp(0) an timestamp(1).
1 REPLY
SN
Enthusiast

Re: the problem of fastload the data about time

hi,

Make sure you supply the data as character, enclosed within quotes - '2008-07-23 11:47:04'

timestamp(0) - this will allow 'yyyy-mm-dd hh:mm:ss'
timestamp(1) - this will allow 'yyyy-mm-dd hh:mm:ss.m'
timestamp(6) - this will allow 'yyyy-mm-dd hh:mm:ss.mmmmmm'

hth,