Convert date/time to date in SQL Server 2000 statement

[Greg Wiskotter]

Can this be done?

tia

[Aaron Bertrand - MVP]

Yes, can you show an example of what you are looking for? Maybe:

SELECT CONVERT(CHAR(8), GETDATE(), 112)





"Greg Wiskotter" <dsfdfsdfdfsdfsdfwe@sdfsdfsdf34234sdfsd.com> wrote in
message news:#cIASv0lDHA.1672@TK2MSFTNGP09.phx.gbl...

> Can this be done?
>
> tia
>
>
>

[Don Grover]

<%
'This function recieves a date from text string in format dd/mm/yy or
dd/mm/ccyy
'And creates a string that is compatible with inserting into sql as a
datetime field
'If an empty string is passed it just passes back trimmed original
'Write Value Test value to sql database 'datetime' field
'Added 16/04/2003
'If a 2 digit year is passed then 20 is prepended onto year to build a CCYY
year

'---------
'sValues = " NULLIF('" & convdate(sDate) & "','')"
'---------
'pass a date as dd/mm/yy
Function convDate(theDate)
Dim Itemp
If TRIM(theDate) <> "" Then
sTemp = cdate(theDate)
dteArray = Split(sTemp,"/",-1,1)
If LenB(dteArray(2)) = 2 Then
dteArray(2) = "20" & dteArray(2)
End If
convDate =dteArray(2) & "/" & dteArray(1) & "/" & dteArray(0)
Else
convDate = Trim(theDate)
End If

End Function
%>


"Greg Wiskotter" <dsfdfsdfdfsdfsdfwe@sdfsdfsdf34234sdfsd.com> wrote in
message news:%23cIASv0lDHA.1672@TK2MSFTNGP09.phx.gbl...

> Can this be done?
>
> tia
>
>
>

[Jeff Cochran]

On Mon, 20 Oct 2003 13:50:41 -0700, "Greg Wiskotter"
<dsfdfsdfdfsdfsdfwe@sdfsdfsdf34234sdfsd.com> wrote:

>Can this be done?

FWIW, I prefer to handle the display of the date/time in the VBScript
instead of the query. I don't know that there's any difference in
performance or utility, it just seems cleaner to me to handle the
presentation in the ASP code rather than the query. This assumes a
date/time field in your database and the date isn't simply stored in a
text field. Though that can work too.

When I do need to do a date/time SELECT, I like Aaron's method if it
fits your needs.

Jeff