CONVERT TIME & TRIM DATE

[RENEE705]

I need help converting time to an AM/PM time format
our database displays time in 4 digits : 0006, 0737, 1217, 2149. I am
finding that 0006 is 12:06 AM and 1217 is 12:17 PM, etc.
The date displays: 2007-03-09 00:00:00.000, how do I have it display the date
as 03-09-2007?

Thanks.

 

[kingston via AccessMonster.com]

Specify the display format of the control or field: mm-dd-yyyy

 

[RENEE705]

Data type: datetime (mm-dd-yyyy 12:00:00 AM) I only want to display the date
not the time stamp so just mm-dd-yyyy

Specify the display format of the control or field: mm-dd-yyyy

I need help converting time to an AM/PM time format
our database displays time in 4 digits : 0006, 0737, 1217, 2149. I am

[quoted text clipped - 3 lines]

Thanks.

 

[John W. Vinson]

I need help converting time to an AM/PM time format
our database displays time in 4 digits : 0006, 0737, 1217, 2149. I am
finding that 0006 is 12:06 AM and 1217 is 12:17 PM, etc.
The date displays: 2007-03-09 00:00:00.000, how do I have it display the date
as 03-09-2007?

Thanks.

What are the datatypes of these fields? Text? Are these tables linked from
some other database system, or native Access tables?

John W. Vinson [MVP]

 

[RENEE705]

I am in the SQL Server 2005 using the SQL Server Management Studio pulling
from dbo tables from the Ecometry Software program we use in our business.
The datatype is DATETIME format, it looks to be text.

I need help converting time to an AM/PM time format
our database displays time in 4 digits : 0006, 0737, 1217, 2149. I am

[quoted text clipped - 3 lines]

Thanks.

What are the datatypes of these fields? Text? Are these tables linked from
some other database system, or native Access tables?

John W. Vinson [MVP]

 

[John W. Vinson]

I am in the SQL Server 2005 using the SQL Server Management Studio pulling
from dbo tables from the Ecometry Software program we use in our business.

Then I'd suggest posting your question in a SQL/Server newsgroup; this
newsgroup is for Microsoft Access queries. Access has a rather different way
of handling date/time data!

John W. Vinson [MVP]

 

[Jamie Collins]

Then I'd suggest posting your question in a SQL/Server newsgroup; this
newsgroup is for Microsoft Access queries. Access has a rather different way
of handlingdate/timedata!

Not greatly different, IMO. For example, SQL Server dates are also
based on double float values; certainly they are treated differently
(with more respect for strongly-typed data?) e.g. you don't often see
people doing my_date + 1 in SQL Server land, even though the behaviour
is the same as for Access/Jet.

Jamie.

--