Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rmellnick
Starting Member
4 Posts |
 Posted - 2004-07-21 : 17:06:49
|
| I programed some tsql statements against a sql server that work well but was asked to include access as well. Well I used the convert function in the select statement to trip off the time from a date\time field.Here is the select statement.Select cba_batchname,convert(varchar,cba_committime,110),cba_commit_id from check_batch_audit where cba_filecabinet = 'AXCheckScan'is there any equivalent function in access?Thanks |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-07-21 : 19:19:08
|
| Access uses the FORMAT function to manipulate date strings. e.g.Format(cba_committime, "dd-mmm-yyyy") to get the date, orFormat(cba_committime, "hh:mm:ss") to get the time. |
 |
|
|
|
|
|
tsql and access