In my web application I have a table which holds a "Last updated" column.
Initially the database was an Access one , but was later upscaled to SQL
Server. The "Last updated" column's datatype in Access was date/time.
In my program I fill in this entry by using the vbscript function Date.
When I look at the actual tables I see that the correct date gets placed
Heres my problem:
I have another page on my site where I display the date when this entry was
I use a query something like
SELECT *,convert(varchar(1000),Information) as Information FROM Schools
WHERE SchoolId='" & myid
The problem is that this "Last updated" entry comes out blank. I'm sure
that I need to somehow use a convert statement with a SQL server datetime
datatype, but how ?