| TeleFlow Forums http://teleflow.org/phpbb/ |
|
| how to get time select statement into variable http://teleflow.org/phpbb/viewtopic.php?f=10&t=173 |
Page 1 of 1 |
| Author: | totalimpact [ Thu Sep 16, 2004 10:25 pm ] |
| Post subject: | |
SELECT DATE_ADD(NOW(), INTERVAL "@VARIABLE" MINUTE); <br> <br>I made this time/math select statement in MySQL - how can i bring the results back into a TeleFlow variable? I am not sure what to define the original select statement as in the local variable. |
|
| Author: | Tim [ Fri Sep 17, 2004 8:56 am ] |
| Post subject: | |
Like this: <br> <br>SELECT DATE_ADD(NOW(), INTERVAL "@VARIABLE" MINUTE) AS NEWDATE FROM [tablename]; <br> <br>The above statement gives the result a column name. When used in a TeleFlow SQL Statement step, TeleFlow will populate the variable @NEWDATE for you automatically. |
|
| Page 1 of 1 | All times are UTC - 8 hours [ DST ] |
| Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |
|