cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
353
Views
0
Helpful
2
Replies

Coverting a date in string format to date for prompt playback

molivere17982
Level 1
Level 1

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.

2 Replies 2

geoff
Level 10
Level 10

It's come up quite a few times before - please do a search.

Regards,

Geoff

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?

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: