Notes Using SQL Server 2000
I need date time in the below format using current date/time before the slash and and current date/time + 6 days after the slash added with the time zone offset as indicated below.
Further description of format:
Start and end dates separated by a forward slash (/). The start is specified by the format (YYYY-MM-DD), followed by the letter ‘T’, the time of the day when the sale starts, followed by an expression of the timezone for the sale. The end date should be in the same format.
Thanks in advance