We are in the US Central timezone.Īny thoughts how I can do this for a view in SQL 2000? SUBSTRING(, 13, 2)īut the last 4 characters are the offset from UT that I need to deal with since it would be good to have the time correct for our timezone and correct for the date if the corrected time changes that. If I use this, I can get the time and date formatted as requested:
I've parsed through the string and concatenated it into close to what I need but there is a difficult part that I'm not sure how to handle.īasically the first 8 characters are the date (YYYY/MM/DD) and the next 6 are HH:MM:SS followed by microseconds (?) after the period. I need to present this in a view so it is more human readable. We have an application where the date-time stamp is stored as varchar(50) instead of datetime.
0 kommentar(er)
