469,950 Members | 2,061 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,950 developers. It's quick & easy.

Help Parsing RFC822 Formatted Date

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

Oct 17 '07 #1
3 4977
"VUNETdotUS" wrote:
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()
}
--
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.

Oct 17 '07 #2
On Oct 16, 10:57 pm, VUNETdotUS <vunet...@gmail.comwrote:
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

Oct 17 '07 #3
On Oct 17, 1:51 pm, "Dave Anderson" <NPQRWPDWZ...@spammotel.com>
wrote:
"VUNETdotUS" wrote:
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()
}

--
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

Oct 18 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Gerrit Holl | last post: by
reply views Thread by Michael B Allen | last post: by
3 posts views Thread by dont bother | last post: by
8 posts views Thread by yerk5 | last post: by
5 posts views Thread by John Smith | last post: by
4 posts views Thread by Nemesis | last post: by
1 post views Thread by praba kar | last post: by
5 posts views Thread by Mahesha | last post: by
reply views Thread by Nikolaus Schulz | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.