CONVERT TIME & TRIM DATE

  • Thread starter Thread starter RENEE705
  • Start date Start date
R

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.
 
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
Click to expand...
[quoted text clipped - 3 lines]
Thanks.
Click to expand...
Click to expand...
 
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.
Click to expand...

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]
 
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
Click to expand...
[quoted text clipped - 3 lines]
Thanks.
Click to expand...

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]
Click to expand...
 
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.
Click to expand...

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]
 
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!
Click to expand...

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.

--
 
Back
Top