Time Convert

  • Thread starter Thread starter googlinggoogler
  • Start date Start date
G

googlinggoogler

Hello,

I have a database that I have been querying from my visual basic 6
program to take my access DB and convert it to excel.

I use a multitude of SQL queries to get it to the format I desire, but
i have a time column that has both the date and time within them. When
I open the excel sheet, I only get the date displayed but the time is
there I just have to reformat the column.

Is there a way to query my Access database in such a way I only have
the time and therefore wont see the date?

Basically without knowing exactly what Im typing i have something as
follows (which obviously doesnt work, hence my post ! heh)

SELECT time(convert(), something here, and here) AS DurrationRunning,
Value0 as LightOn
FROM Table1;

So as you can see my plan is to be able to "export" the relevant field
but change the fields name and also change the format to time, and
then export the rest of the fields and change there name on the fly
with "AS"

Thanks In advance

David
 
Hello,

I have a database that I have been querying from my visual basic 6
program to take my access DB and convert it to excel.

I use a multitude of SQL queries to get it to the format I desire, but
i have a time column that has both the date and time within them. When
I open the excel sheet, I only get the date displayed but the time is
there I just have to reformat the column.

Is there a way to query my Access database in such a way I only have
the time and therefore wont see the date?

Basically without knowing exactly what Im typing i have something as
follows (which obviously doesnt work, hence my post ! heh)

SELECT time(convert(), something here, and here) AS DurrationRunning,
Value0 as LightOn
FROM Table1;

So as you can see my plan is to be able to "export" the relevant field
but change the fields name and also change the format to time, and
then export the rest of the fields and change there name on the fly
with "AS"

Thanks In advance

David
Click to expand...

should just be able to use in your select statement something like
HOUR([Date].
) or minute or second etc
 
Is there a way to query my Access database in such a way I only have
the time and therefore wont see the date?
Click to expand...

TimeValue([datefield])

will extract the time.

John W. Vinson [MVP]
 
Back
Top