Michael Stassen wrote:
So, take a look at yarn_date.txt and let us know.
Yes, you're right . . . there was an extra tab stop. When I deleted the
extra tab, the date field were retained successfully. Thanks!
--
Lola - mailto:[EMAIL PROTECTED]
http://www.lolajl.net | Blog at http://www.l
Lola J. Lee Beno wrote:
Here's an example of one of the tables where the date was retained
successfully, with the string to the right of the decimal point being
trimmed:
1Cobweb2005-01-13 15:21:50.654149
2Lace Weight2005-01-13 15:21:50.654149
3Sock2005-01-13 15:21:50.6
Michael Stassen wrote:
Just a quick reply for now . . .
Ummm, if you delete the numbers to the *left* of the decimal point,
"2005-01-15 10:15:42.41837" will turn into ".41837", which is still not
a valid datetime. You need to delete the numbers to the *right* of the
decimal point (which I ex
Lola J. Lee Beno wrote:
I have a bunch of data where one of the columns is a date field. Here's
a sample of the data that I have:
141415010001 02005-01-15 10:15:42.41837
281512010002 02005-01-15 10:22:37.756594
36
