| TeleFlow Forums http://teleflow.org/phpbb/ |
|
| Process Dates within an Insert Statement http://teleflow.org/phpbb/viewtopic.php?f=10&t=330 |
Page 1 of 1 |
| Author: | wlwoody [ Wed Feb 15, 2006 3:20 pm ] |
| Post subject: | |
Two character fields each contain a date in the format of '02/14/06'. <br> <br>A section of the VALUES statement: <br>VALUES <br> ('F', <br> '@START_TIME', <br> '@ST_AM_PM', <br> CTOD(@START_DATE), <br> '@END_TIME', <br> '@END_AM_PM, <br> CTOD(@END_DATE),... <br>results in: <br>VALUES <br> ('F', <br> '730', <br> '1', <br> CTOD(), <br> '730', <br> '2, <br> CTOD(), <br> <br>Why is the insert command trying to insert 'CTOD()' in place of the date 02/14/06? <br> <br>Thanks again for the response... |
|
| Author: | admin [ Wed Feb 15, 2006 3:35 pm ] |
| Post subject: | |
'2, <br> <br>should be <br> <br>'2', <br> <br>Hint: Create test statements with your DB interface environment when you get stuck. Copy / Paste faulty statements into it to debug, and then update TeleFlow. <br> <br>Good luck! |
|
| Page 1 of 1 | All times are UTC - 8 hours [ DST ] |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|