How to get date time to display like 01/01/2005 16:14:10?

[ziggs]

How to get date time to display like 01/01/2005 16:14:10?

Here's something that I found works against an Oracle database.
However, I'm not getting the same results against a SQL 2000 database.
Can anyone point out the correction needed? With the following, the
time displays correctly, but no date at all.

<%d=formatdatetime(rs2("Begin_Time"), 2)
if mid(d,2,1)="/" then d="0" & d
if mid(d,5,1)="/" then d=left(d,3) & "0" & mid(d,4)
Response.Write (d) & "&nbsp;"
Response.Write formatdatetime(rs2("Begin_Time"), 4)
if second(rs2("Begin_Time")) < 10 then
Response.Write ":0" & second(rs2("Begin_Time"))
else
Response.Write ":" & second(rs2("Begin_Time"))
end if%>

TIA

[Dave Anderson]

ziggs wrote:

How to get date time to display like 01/01/2005 16:14:10?
Construct a better question. Is your date portion mm/dd/yyyy or dd/mm/yyyy ?
Here's something that I found works against an Oracle database.
However, I'm not getting the same results against a SQL 2000 database.
Can anyone point out the correction needed? With the following, the
time displays correctly, but no date at all.

<%d=formatdatetime(rs2("Begin_Time"), 2)
if mid(d,2,1)="/" then d="0" & d
if mid(d,5,1)="/" then d=left(d,3) & "0" & mid(d,4)
Response.Write (d) & "&nbsp;"
Response.Write formatdatetime(rs2("Begin_Time"), 4)
if second(rs2("Begin_Time")) < 10 then
Response.Write ":0" & second(rs2("Begin_Time"))
else
Response.Write ":" & second(rs2("Begin_Time"))
end if%>

Among other things, you can get SQL Server to formet your dates:
http://msdn.microsoft.com/library/en...ca-co_2f3o.asp

--
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. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

[Bob Barrows [MVP]]

ziggs wrote:

How to get date time to display like 01/01/2005 16:14:10?

http://www.aspfaq.com/show.asp?id=2313 vbscript
http://www.aspfaq.com/show.asp?id=2040 help with dates
http://www.aspfaq.com/show.asp?id=2260 dd/mm/yyy confusion
http://www.aspfaq.com/show.asp?id=2023 date delimiters

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

[Ken Jenkins]

some tips
http://www.powerasp.com/content/new/...e-and-time.asp

"ziggs" <zi***@hotmail.com> wrote in message
news:5p********************************@4ax.com...

How to get date time to display like 01/01/2005 16:14:10?

Here's something that I found works against an Oracle database.
However, I'm not getting the same results against a SQL 2000 database.
Can anyone point out the correction needed? With the following, the
time displays correctly, but no date at all.

<%d=formatdatetime(rs2("Begin_Time"), 2)
if mid(d,2,1)="/" then d="0" & d
if mid(d,5,1)="/" then d=left(d,3) & "0" & mid(d,4)
Response.Write (d) & "&nbsp;"
Response.Write formatdatetime(rs2("Begin_Time"), 4)
if second(rs2("Begin_Time")) < 10 then
Response.Write ":0" & second(rs2("Begin_Time"))
else
Response.Write ":" & second(rs2("Begin_Time"))
end if%>

TIA

[ziggs]

The format that I'm looking for is mm/dd/yyyy for the 01/01/2005
example. I read the other two posts and their links. However, I'm
just more confused now.

On Tue, 21 Jun 2005 08:02:21 -0500, "Dave Anderson"
<GT**********@spammotel.com> wrote:

ziggs wrote:

How to get date time to display like 01/01/2005 16:14:10?

Construct a better question. Is your date portion mm/dd/yyyy or dd/mm/yyyy ?

Here's something that I found works against an Oracle database.
However, I'm not getting the same results against a SQL 2000 database.
Can anyone point out the correction needed? With the following, the
time displays correctly, but no date at all.

<%d=formatdatetime(rs2("Begin_Time"), 2)
if mid(d,2,1)="/" then d="0" & d
if mid(d,5,1)="/" then d=left(d,3) & "0" & mid(d,4)
Response.Write (d) & "&nbsp;"
Response.Write formatdatetime(rs2("Begin_Time"), 4)
if second(rs2("Begin_Time")) < 10 then
Response.Write ":0" & second(rs2("Begin_Time"))
else
Response.Write ":" & second(rs2("Begin_Time"))
end if%>

Among other things, you can get SQL Server to formet your dates:
http://msdn.microsoft.com/library/en...ca-co_2f3o.asp

[McKirahan]

"ziggs" <zi***@hotmail.com> wrote in message
news:f0********************************@4ax.com...

The format that I'm looking for is mm/dd/yyyy for the 01/01/2005
example. I read the other two posts and their links. However, I'm
just more confused now.

[snip]

Will this help? Watch for word-wrap.

Response.Write MyFormatDateTime(rs2("Begin_Time"))

Function MyFormatDateTime(when)
Dim strMDY
strMDY = Right(100+DatePart("m",when),2) & "/"
strMDY = strMDY & Right(100+DatePart("d",when),2) & "/"
strMDY = strMDY & DatePart("yyyy",when)
Dim strHMS
strHMS = Right(100+DatePart("h",when),2) & ":"
strHMS = strHMS & Right(100+DatePart("n",when),2) & ":"
strHMS = strHMS & Right(100+DatePart("s",when),2)
MyFormatDateTime = strMDY & " " & strHMS
End Function

[znott2]

It didn't work. It said that the "m" in

strMDY = Right(100+DatePart("m",when),2*) & "/"

was an invalid character.

[McKirahan]

<zn****@hotmail.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
It didn't work. It said that the "m" in

strMDY = Right(100+DatePart("m",when),2*) & "/"

was an invalid character.
Are you sure?

Retrieving Specific Portions of a Date and Time Value
http://www.microsoft.com/technet/scr..._vbs_ufbq.mspx
I suspect that the value of "when" is not a valid date.

Try this:

Response.Write "<br>when = " & when
Response.Write "<br>Month = " & DatePart("m",when)

at the top of the Function and see what you get.

Post the results if there' still a problem.