InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
There Is A Column With Date In It. If I Want To Get Just Month How It Can Be Done? Can I Use Sub String? |
|
Answer» Sub string is used with char FIELDS. So it cannot be used. To extract month from a DATE COLUMN, ex select extract (month from ). Same THING for year or day. Or hour or minutes if it’s a time stamp (select extract (MINUTE from column name). Sub string is used with char fields. So it cannot be used. To extract month from a date column, ex select extract (month from ). Same thing for year or day. Or hour or minutes if it’s a time stamp (select extract (minute from column name). |
|