Insert Date And Time With Seconds into Linked Sql Table i 1

[PWise]

Database
MSAccess .mdb with linked Sql Server Backend.

Problem
Using this Syntax

mydb.Execute "insert into TimeClock (Empid,ClockTime,Status) values (" & Me.Empid & ",#" & Now() & "#," & Me.TimeStatus & ")"

inserts the to the ClockTime field in this format mm/dd/yyyy HH:MM:00.

I need it in this format mm/dd/yyyy HH:MM:SS.

 

[SkipVought]

Hi,

How about this...

mydb.Execute "insert into TimeClock (Empid,ClockTime,Status) values (" & Me.Empid & ",#" & [b]Format(Now(),"mm/dd/yyyy HH:NN:SS") & "#," & Me.TimeStatus & ")"

Skip,

_[red][/red]

 

[PWise]

Thank You Skip!

But Sorry still no Seconds.

Pwise

 

[Remou]

Just guessing:

date()+time()

 

[PWise]

Thank You Remou!

But Sorry still no Seconds.

Pwise

 

[SkipVought]

What's the precision of the field that you are updating with Date/Time?

ONE SECOND is
[tt]
0.0000115741
[/tt]

Skip,

_[red][/red]

 

[PWise]

thanks Skip for putting me on the right track it was a sql server smalldatetime I changed it to a datetime which stores seconds.

Have A Star!

Pwise