on 04-17-2013 12:31 AM
Hi,
How can I get de hour and minutes from a Timestamp field
The database is MS SQL SERVER 2008
Hello Jose,
Do you want to extract hour and minute from a datetime column or timestamp?
If it is datetime, you can create an object with the following definition:
select DATEPART(hour,column name) from table.
Similarly for minute,
select DATEPART(minute, column name) from table.
Thanks,
Madhumitha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.