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?
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide