in reply to Timestamp help
Attention: Pattern used in insert is not real.INSERT INTO mytable (mytimestamp) VALUES (StrToDateTime("%month %day %h24:%mi:%ss.%xxx",?));
Or, you can reformat the timestamp in Perl code (as advised above) into rdbms native string format of timestamp - some rdbms automatically convert properly formatted string to timestamp.
But, in both cases, your code will depend on rdbms capabilities.
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^2: Timestamp help
by LesleyB (Friar) on Sep 13, 2008 at 22:19 UTC |