|
||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread |
| SQL - Questions and Answers Have a SQL question? Post it here. First do a search to see if someone hasn't already answered it. |
|
||||||
|
|
|
LinkBack | Thread Tools | Search this Thread |
09-17-2007, 06:54 AM
|
|||
|
|||
ANY dialect question:
How to retrive data from a column which contains both date and timeHow to retrive data from a column which contains both date and time
For eg:- A col named date_entered has a values 22/09/2000 12:22:52 22/09/2000 6:5:15 22/09/2000 12:22:52 22/09/2000 8:15:45 how shal i retrieve data for the value which has 22/09/2000 12:22:52     
|
|
12-22-2007, 05:30 PM
|
|||
|
|||
|
ANY answer.
Re: How to retrive data from a column which contains both date and time
[quote=anu;464]How to retrive data from a column which contains both date and time
For eg:- A col named date_entered has a values 22/09/2000 12:22:52 22/09/2000 6:5:15 22/09/2000 12:22:52 22/09/2000 8:15:45 how shal i retrieve data for the value which has 22/09/2000 12:22:52[/find the salary of 12 people drawing less than 28000.
|
