I have a XML file where i have a date child with this format: 1958-07-11+01:00
Currently I import this as plain text to my SQL Server, but I would like for my SQL database to understand this, so I can select only the last 7 days for my search. How do I convert this to a time-format my SQL Server understands and how do I then output only the rows with a change date in the last 7 days? Thanks!
No comments:
Post a Comment