I just want the time to appear
-
Hi all, I am using Sql Server 2005, ASP.Net and VB.net The problem is that, i am using the datetime data type for the CourseTime column in the Course table, but when i want to display the time using a Gridview the date "1/1/1900" appears by default and i don't want any date to appear. How to solve this. Thanks in advance for your help
yasso
-
Hi all, I am using Sql Server 2005, ASP.Net and VB.net The problem is that, i am using the datetime data type for the CourseTime column in the Course table, but when i want to display the time using a Gridview the date "1/1/1900" appears by default and i don't want any date to appear. How to solve this. Thanks in advance for your help
yasso
Use
convert(varchar(10), 'YOUR DATE COLUMN', 14)in the SP/SQL that populates the grid. SG -
Use
convert(varchar(10), 'YOUR DATE COLUMN', 14)in the SP/SQL that populates the grid. SG -
Thanks for your help but I didn't understand, what is SP/SQL and where to find it, please give me more details
yasso
those are store proc and SQL query language...you can look for more info from SQL book online << >>