chrisryhal
asked on
Format SYSTEM.DATETIME.NOW
I have the below SQL Insert statement in my WinApp and I would like to make the formatting (mm/dd/yyyy) instead of the default mm/dd/yyy hh:mm
I am trying to do this an easy way without having to create a declaration first, because i know I can do it like so:
Dim strdate As DateTime
strdate = System.DateTime.Now
Dim displayString As String
displayString = Format(strdate, "MM/dd/yyyy")
\\\\\\\\\\\\\\\INSERT STATEMENT\\\\\\\\\\\\\
strSQLInsert = strSQLInsert & "'" & Trim(System.DateTime.Now) & "',"
I am trying to do this an easy way without having to create a declaration first, because i know I can do it like so:
Dim strdate As DateTime
strdate = System.DateTime.Now
Dim displayString As String
displayString = Format(strdate, "MM/dd/yyyy")
\\\\\\\\\\\\\\\INSERT STATEMENT\\\\\\\\\\\\\
strSQLInsert = strSQLInsert & "'" & Trim(System.DateTime.Now) & "',"
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER