Help Parsing RFC822 Formatted Date

[VUNETdotUS]

How can I parse RFC822 date format Sat, 13 Oct 2007 22:09:03 PDT to MM/
DD/YYYY?
Any reference you can recommend?
Thanks

 

[Dave Anderson]

How can I parse RFC822 date format Sat, 13 Oct 2007 22:09:03 PDT to
MM/DD/YYYY?

This is not really an ASP question, but here's a JScript answer:

Date.prototype.toMDCY = function() { ...insert code for
formatting... }**
return new Date("Sat, 13 Oct 2007 22:09:03 PDT").toMDCY()

http://msdn2.microsoft.com/en-us/library/cd9w2te4.aspx

Of course, this is time-zone dependent. On my system, this becomes
10/14/2007.

If you can stuff it in a SQL date variable, MSSQL has DATETIME styles for
converting to character data:

CONVERT(VARCHAR(10), @YourDateVariableHere, 101)
http://msdn2.microsoft.com/en-us/library/ms187928.aspx

I really couldn't say what VBScript would require.



**For example, assume you have already dealt with Number.prototype.pad...

Date.prototype.toMDCY = function() {
return (this.getMonth()+1).pad(2) + "/" + this.getDate().pad(2) +
"/" + this.getFullYear()
}

 

[VUNETdotUS]

How can I parse RFC822 date format Sat, 13 Oct 2007 22:09:03 PDT to MM/
DD/YYYY?
Any reference you can recommend?
Thanks

What I mean is there an easier way to parse other than splitting by
space, converting Oct to 10, etc.
Thanks

 

[VUNETdotUS]

This is not really an ASP question, but here's a JScript answer:

Date.prototype.toMDCY = function() { ...insert code for
formatting... }**
return new Date("Sat, 13 Oct 2007 22:09:03 PDT").toMDCY()

http://msdn2.microsoft.com/en-us/library/cd9w2te4.aspx

Of course, this is time-zone dependent. On my system, this becomes
10/14/2007.

If you can stuff it in a SQL date variable, MSSQL has DATETIME styles for
converting to character data:

CONVERT(VARCHAR(10), @YourDateVariableHere, 101)
http://msdn2.microsoft.com/en-us/library/ms187928.aspx

I really couldn't say what VBScript would require.

**For example, assume you have already dealt with Number.prototype.pad...

Date.prototype.toMDCY = function() {
return (this.getMonth()+1).pad(2) + "/" + this.getDate().pad(2) +
"/" + this.getFullYear()
}

--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms.

thanks Dave