How to change a NVCHAr to a DATE

rtr1900 · June 25th, 2009, 03:15 AM

Hi,

I have in my SQL table a VAR where I save the date when a user enters.It is a NVARCHAR
Something like "26/06/2009 01:25:05"
But now I want to select only the dates that are bigger than a date. But the date in the table is a NVARCHAR and the one I use to check with is a real type of date. My code is

Code:

 
date_today=date()-1
date_today=date_today &"05:00:00"
sql="SELECT * from comercials where real_date >='"&date_today&"'"

So "real_date" is a NVCHAR and can not be checked as a DATEformat.

i tried several thing but my mind is getting fuzzy

Thx already!

rtr1900 · June 25th, 2009, 06:28 AM

Hi everyone,
afert a cup of coffee and surfing the net I found the solution to my problem.
here it is, in case anybody would come over the same problem.
I used the command CONVERT

CONVERT(DATETIME,date_real) >='"&date_new&"'

Date_real is the NVARCHAR and is converted to a datetime type.

Well I am happy again!!!!

Greetz

chroniclemaster1 · June 30th, 2009, 12:53 AM

Why not take the user input as a date from the very beginning?