time function in SQL???

[anneoctaaf]

In my database there is a datetime record. Now i only need the time from the database. Is there a sql function that can filter the time from my datetime record? I mean something like this:

SELECT time(value)
FROM Globals;

 

[mbalent]

In MS SQL Server you can use the following:

select convert(varchar(8),getdate(),8)

Which gives you the current time.

or

select convert(varchar(8), colname,8) from table

where colname is the datetime column.

 

[blktoptrvl]

What database are you using?

 

[anneoctaaf]

msaccess, which should be able to handle some string function like the example above...thanx!

 

[blktoptrvl]

It looks like you have to do the work yourself...


SELECT {fn hour(table.datefield)},
{fn minute(table.datefield)}
FROM table ;[/color blue]

Where table is the table of interest and datefield is the field containing the time you want.