![]() ![]() ![]() There is no date in the field it is just a time so for example it reads 1410 and I want it to say 2:10 P.M. Everytime I try to use any type of datetime convert it tells me that the conversion of a char data type to a datetime data type resulted in an out of range datetime value. Is their a cast or convert or some type of sql function I can use to select the appointment time in standard time format? I have been searching online and just haven't found anything yet.Thanks in advance!SherriĪnd the military time format would be?you can always do:select convert(datetime, yourDateColumn)from yourTableand then format that datetime in whatever way you want in the report_Causing trouble since 1980blog: Add-in that does a few things: sross81 I am doing this report in crystal and I tried to use crystal tools but it crystal recognizes it as a string so it won't let me set the time format. Hello,I have a database field that is just an appointment time but it is stored as a char and it appears to be in military time as well.For reporting purposes I am creating a query that will use the appointment time and I need it to display in standard time format. We've got lots of great SQL ServerĮxperts to answer whatever question you can come up with. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |