    SQL&gt; SELECT TO_CHAR(date &#39;1982-03-09&#39;, &#39;DAY&#39;) day FROM dual;
    
    DAY
    ---------
    TUESDAY
    
    SQL&gt; SELECT TO_CHAR(date &#39;1982-03-09&#39;, &#39;DY&#39;) day FROM dual;
    
    DAY
    ---
    TUE
    
    SQL&gt; SELECT TO_CHAR(date &#39;1982-03-09&#39;, &#39;Dy&#39;) day FROM dual;
    
    DAY
    ---
    Tue

(Note that the queries use ANSI date literals, which follow the ISO-8601 date standard and avoid date format ambiguity.)

Nearly ten years late to the party, but I think it&#39;s neccessary to enhance @Zohaib &#39;s answer as it&#39;s result depend on the language of the client. If you display the week day name to a user, it&#39;s absolutely fine, but if your code depends on it, I&#39;d rather control the language like so:

    SQL&gt; SELECT TO_CHAR(date &#39;1982-03-09&#39;, &#39;DAY&#39;, &#39;NLS_DATE_LANGUAGE = ENGLISH&#39;) day FROM dual;
    
    DAY
    ---------
    TUESDAY
    
    SQL&gt; SELECT TO_CHAR(date &#39;1982-03-09&#39;, &#39;DY&#39;, &#39;NLS_DATE_LANGUAGE = ENGLISH&#39;) day FROM dual;
    
    DAY
    ---
    TUE
    
    SQL&gt; SELECT TO_CHAR(date &#39;1982-03-09&#39;, &#39;Dy&#39;, &#39;NLS_DATE_LANGUAGE = ENGLISH&#39;) day FROM dual;
    
    DAY
    ---
    Tue

To do this in Oracle sql, I tried like this and it worked for me 
```
SELECT 
	START_DATE,
	CASE WHEN START_DAY = 7 THEN &#39;SUNDAY&#39;
	     WHEN START_DAY = 1 THEN &#39;MONDAY&#39;
		 WHEN START_DAY = 2 THEN &#39;TUESDAY&#39;
		 WHEN START_DAY = 3 THEN &#39;WEDNESDAY&#39;
		 WHEN START_DAY = 4 THEN &#39;THURSDAY&#39;
		 WHEN START_DAY = 5 THEN &#39;FRIDAY&#39;
		 WHEN START_DAY = 6 THEN &#39;SATURDAY&#39;
	END DAY_NAME
FROM 
(SELECT 
	TO_CHAR(T.START_DATE, &#39;DY&#39;) START_DAY,
    TO_CHAR(T.START_DATE, &#39;MM/DD/YYYY&#39;) START_DATE
	   
FROM 
	TABLE T )
```


I know that a fragment&#39;s view hierarchy has to be inflated in onCreateView, but what other functionality can be in onCreateView vs. what should wait for onActivityCreated? My current implementation uses separate activities for everything, and a typical activity does most of its work in its onCreate method, including inflating the view, setting the content view, initializing the various widgets with data, setting up listeners, etc.

So can this probably all be moved into onCreateView, or should some functions be put into an onActivityCreated method instead?

Android Fragment onCreateView vs. onActivityCreated

I have an old computer which I converted into a minecraft server.  I have 2 minecraft servers running simultaneously, one on port 25565 (default) and one on port 25566.  

I bought the domain something.com and pointed it to my server.  Right now, in the game you type something.com to get into the first server and something.com:25566 to get into the other server.

Is there a way to set one.something.com to point to the first server and two.something.com to point to the second server?  I own the (centos) server, have root access, and everything else.  The domain is controlled by no-ip if that makes a difference.  I know that DNS has no relationship to port numbers but if there a program I can install to make this work?

Thanks :)

Can I configure a subdomain to point to a specific port on my server

Given `03/09/1982` how can we say it is which week day. In this case it will be `Tue`.

Is it possible to get in a single query?


How to get the week day name from a date?

<p>Given <code>03/09/1982</code> how can we say it is which week day. In this case it will be <code>Tue</code>.</p>
<p>Is it possible to get in a single query?</p>


By default, Oracle SQL developer displays date values as `15-NOV-11`. I would like to see the time part (hour/minute/second) by default. 

Is there a way to configure this within Oracle SQL Developer?

How can I set a custom date time format in Oracle SQL Developer?

How to uninstall / completely remove Oracle 11g (client)?

deinstall.bat doesn&#39;t work.

**Edit:**  Further discussion related to why this question was closed and deleted:  https://meta.stackexchange.com/questions/190441/why-was-this-question-related-to-uninstalling-the-oracle-database-client-deleted

How to uninstall / completely remove Oracle 11g (client)?

Is the &#39;AS&#39; keyword required in Oracle to define an alias name for a column in a SELECT statement? 

I noticed that 

    SELECT column_name AS &quot;alias&quot;

 is the same as

    SELECT column_name &quot;alias&quot;

I am wondering what the consequences are of defining a column alias in the latter way. 

Is the &#39;as&#39; keyword required in Oracle to define an alias?

I have a mySQL query to get columns from a table like this:

    String sqlStr=&quot;select column_name 
    from information_schema.COLUMNS 
    where table_name=&#39;users&#39; 
    and table_schema=&#39;&quot;+_db+&quot;&#39; 
    and column_name not in (&#39;password&#39;,&#39;version&#39;,&#39;id&#39;)&quot;

How do I change the above query in Oracle 11g database? I need to get columns names as a resultset for table &#39;users&#39; excluding certain columns, specifying a schema. Right now I have all tables in my new tablespace, so do I specify tablespace name in place of schema name?

Also is there a generic HQL for this? In my new Oracle database (I am new to Oracle), I only have tablespace name, so is that equivalent to schema name (logically?)


Oracle query to fetch column names

I need to look up rows within a particular time frame.

    select * 
    from TableA 
    where startdate &gt;= &#39;12-01-2012 21:24:00&#39; 
      and startdate &lt;= &#39;12-01-2012 21:25:33&#39;

I.e.: I need to look up rows with timestamp precision of SECONDS. How do I achieve this?

FYI: The `startdate` column is of type `TIMESTAMP`.

Oracle SQL : timestamps in where clause

I want to get todays date given a time zone in Paul Eggert format(`America/New_York`) in PHP? 

Get current date, given a timezone in PHP?

In my SQL query how do i make it find the records in the last 24 hours?
Eg

       SELECT * FROM news WHERE date &lt; 24 hours

I usually do it by setting a variable to date() - 1 day and comparing it to that but I wondered whether the sql query way was faster?

Find records with a date field in the last 24 hours

As I know `getHours()`, `getMinutes()` and `getSeconds()` are all deprecated in Java and they are replaced with `Calendar.HOUR_OF_DAY`, `Calendar.MINUTE`, `Calendar.SECOND`.

These will in fact return the hour, minute and second for that particular moment. However, I would want to retrieved the hours and minutes from a Date variable. For instance,

say the time retrieved from database is 
    
    time = Thu Jan 01 09:12:18 CET 1970;

    int hours = time.getHours();
    int minutes = time.getMinutes();
    int seconds = time.getSeconds();

By retrieving the hours, minutes, and seconds, I get

    hours = 9
    minutes = 12
    seconds = 18

So, how do I use Calendar for this function? Although the `getHours()` has been deprecated but it still worked. I would still like to know if there is an alternative to this.

Java getHours(), getMinutes() and getSeconds()

I&#39;m really stuck with adding X minutes to a datetime, after doing lots of google&#39;ing and PHP manual reading, I don&#39;t seem to be getting anywhere.

The date time format I have is: 

`2011-11-17 05:05`: `year-month-day hour:minute`

Minutes to add will just be a number between 0 and 59

I would like the output to be the same as the input format with the minutes added.

Could someone give me a working code example, as my attempts don&#39;t seem to be getting me anywhere?

Adding minutes to date time in PHP

I am using a JavaScript `Date` class &amp; trying to get the current date using `getDate()` method. But obviously it is loading system date &amp; time. I am running the code from India but I want to get the date &amp; time of UK using the same method. How can I do that ?

Get time of specific timezone

How do I get the day of a week in integer format? I know ToString will return only a string. 

    DateTime ClockInfoFromSystem = DateTime.Now;
    int day1;
    string day2;
    day1= ClockInfoFromSystem.DayOfWeek.ToString(); /// it is not working
    day2= ClockInfoFromSystem.DayOfWeek.ToString(); /// it gives me string

How to get the integer value of day of week

I have a DataFrame `df` like the following (excerpt, &#39;Timestamp&#39; are the index):

    Timestamp              Value
    2012-06-01 00:00:00     100
    2012-06-01 00:15:00     150
    2012-06-01 00:30:00     120
    2012-06-01 01:00:00     220
    2012-06-01 01:15:00      80
    ...and so on.

I need a new column `df[&#39;weekday&#39;]` with the respective weekday/day-of-week of the timestamps.

How can I get this?


Content Type	Original Author	Original Content on Stackoverflow
Question	user1025901	View Question on Stackoverflow
Solution 1 - Oracle	Zohaib	View Answer on Stackoverflow
Solution 2 - Oracle	wolφi	View Answer on Stackoverflow
Solution 3 - Oracle	cluelessgumshoe	View Answer on Stackoverflow

How to get the week day name from a date?

Oracle Problem Overview

Oracle Solutions

Solution 1 - Oracle

Solution 2 - Oracle

Solution 3 - Oracle

Can I configure a subdomain to point to a specific port on my server

Android Fragment onCreateView vs. onActivityCreated

Attributions