06-05-2009 10:28 AM - edited 03-14-2019 04:11 AM
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.
06-05-2009 10:53 PM
It's come up quite a few times before - please do a search.
Regards,
Geoff
06-06-2009 06:25 AM
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?
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: