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)
molivere17982 Sat, 06/06/2009 - 06:25
User Badges:


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?


This Discussion