[dba-SQLServer] Displaying SQL Server Time(7) in Access

Stuart McLachlan stuart at lexacorp.com.pg
Tue Jun 5 22:15:24 CDT 2012

I seem to recall having the same discussion about a year ago where we identified the 
problem with the new SQL Server Date and Time types and ODBC returning them as strings 


On 5 Jun 2012 at 22:14, jwcolby wrote:

> Ahh I figured it out.  I had this working in the past.  The key seems to be not using the time() 
> format but rather using the DateTime format in SQL Server.
> Sorry for the ring.
> John W. Colby
> Colby Consulting
> Reality is what refuses to go away
> when you do not believe in it
> On 6/5/2012 9:38 PM, jwcolby wrote:
> > I am stumped on how to display a SQL Server time value in an Access form while leaving it editable.
> > If I look directly in the table in SQL Server a time is displayed like this: 08:45:00.0000000.
> > Likewise it is displayed in the Access form in that manner which of course is a major annoyance.
> >
> > Access input masks work correctly for stuffing the times in but "formats" such as Short time etc
> > have no apparent effect at all. For reporting I can simply do a left(SomeTime,5) to get HH:MM format
> > but of course I can't do that in the form's text field.
> >
> > So how the heck do I do this format in the form to display just the hour and minute?
> >
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com

Stuart McLachlan

Ph:    +675 340 4392 
Mob: +675 7100 2028
Web: http://www.lexacorp.com.pg

More information about the dba-SQLServer mailing list