Coverting a date in string format to date for prompt playback

Unanswered Question
Jun 5th, 2009
User Badges:

I'm pulling a date from SQL in the following format "YYYYMMDD" (20090619) how can I read this back to the caller? I tried using the set command and the script bombs.



  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
molivere17982 Sat, 06/06/2009 - 06:25
User Badges:

Geoff,


I've done a few searches and found the thread that you replied to dealing with writing datetime to a SQL and changing the format with a SQL query, but I don't do that.


I've found away to do it with substring() and set commands, but it takes like 5 lines of set commands to maker it work and its quite a pause for the caller.


Any ideas?

Actions

This Discussion