A cast to [`timestamp(0)`][1] or [`timestamptz(0)`][1] ***rounds*** to full seconds:

    SELECT now()::timestamp(0);

Fractions are not stored in table columns of this type.

[`date_trunc()`][2] ***truncates*** (leaves seconds unchanged) - which is often what you really want:

    SELECT date_trunc(&#39;second&#39;, now()::timestamp);


  [1]: https://www.postgresql.org/docs/current/datatype-datetime.html
  [2]: https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-TRUNC

**Discard milliseconds:**

    SELECT DATE_TRUNC(&#39;second&#39;, CURRENT_TIMESTAMP::timestamp);


&gt; 2019-08-23 16:42:43

**Discard seconds:**

    SELECT DATE_TRUNC(&#39;minute&#39;, CURRENT_TIMESTAMP::timestamp);

&gt; 2019-08-23 16:42:00


if you just want time, here is the code for postgres

    SELECT DATE_TRUNC(&#39;second&#39;, CURRENT_TIMESTAMP::timestamp)::time;

it will return &#39;time without time zone&#39; data type 

I run Jenkins in its own container. I use the command &quot;nohup java -jar jenkins.war --httpsPort=8443&quot;. 

How do I shut it down safely? Right now, I use the kill command to kill the process.



How to shutdown my Jenkins safely?

I have read on the web that following combination exists : 

**Proprietary Source code + GPL Source code** - &gt; GPL Source code ( All code has to be released under GPL)

**Proprietary Source code + LGPL Source code** - &gt; Proprietary Source code ( All code remains Proprietary )

Now how does **statically/Dynamically** linking GPL and LGPL code works with the above combination?

GPL/LGPL and Static Linking

How can I discard/round the `millisecond` part, better if the `second` part is also removed from a `timestamp` w/o `timezone` ?

Discard millisecond part from timestamp

<p>How can I discard/round the <code>millisecond</code> part, better if the <code>second</code> part is also removed from a <code>timestamp</code> w/o <code>timezone</code> ?</p>


I have this date format: 2011-09-28 18:01:00 (in varchar), and I want to convert it to datetime changing to this format 28-09-2011 18:01:00. How can I do it?

SQL Server Convert Varchar to Datetime

The following image is a part of Microsoft SQL Server 2008 R2 System Views. From the image we can see that the relationship between `sys.partitions` and `sys.allocation_units` depends on the value of `sys.allocation_units.type`. So to join them together I would write something similar to this:

    SELECT  *
    FROM    sys.indexes i
            JOIN sys.partitions p
                ON i.index_id = p.index_id 
            JOIN sys.allocation_units a
                ON CASE
                   WHEN a.type IN (1, 3)
                       THEN a.container_id = p.hobt_id 
                   WHEN a.type IN (2)
                       THEN a.container_id = p.partition_id
                   END 

But the upper code gives a syntax error. I guess that&#39;s because of the `CASE` statement. 
Can anyone help to explain a little?


---
Add error message:

&gt; Msg 102, Level 15, State 1, Line 6 Incorrect syntax near &#39;=&#39;.

![this is the image][1]


  [1]: http://i.stack.imgur.com/HYmiS.jpg

Can I use CASE statement in a JOIN condition?

When using this statement

    create table demo (
        ts timestamp
    )

    insert into demo select current_timestamp

I get the following error:

&gt;Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column

How do I insert the current time to a `timestamp` column?

SQL Server: Cannot insert an explicit value into a timestamp column

I have a table called `countries` and I define the `country_name` column to be unique by creating a “Index/Key” of type “Unique Key” on SQL Server 2008 R2. 

But I have the following questions:

1. will creating “Index/Key” of type “Unique Key” automatically create a non-clustered index on this column?
2. if I change the type from being “Unique Key” to &quot;Index&quot; and I keep the `IsUnique` value to be &quot;Yes&quot;,, then will there be any differences ?
3. so why there are two options “Unique Key” and &quot;Index&quot; I think the two are the same ?

Unique key vs. unique index on SQL Server 2008

A column `height` is integer type in my SQL Server table. I want to do a division and have the result as decimal in my query:

    Select (height/10) as HeightDecimal

How do I cast so that the `HeightDecimal` is no longer integer? Thanks.

How to convert integer to decimal in SQL Server query?

I am trying to loop through an integer array (`integer[]`) in a plpgsql function. Something like this:

    declare
        a integer[] = array[1,2,3];
        i bigint;
    begin
        for i in a
    loop 
        raise notice &quot;% &quot;,i;
    end loop;
    return true;
    end

In my actual use case the integer array `a` is passed as parameter to the function. I get this error:

&gt;     ERROR:  syntax error at or near &quot;$1&quot;
&gt;     LINE 1:   $1

How to loop through the array properly?

Iterating over integer[] in PL/pgSQL

I&#39;m a little new to postgres. I want to take a value (which is an integer) in a field in a postgres table and increment it by one. For example if the table &#39;totals&#39; had 2 columns, &#39;name&#39; and &#39;total&#39;, and Bill had a total of 203, what would be the SQL statement I&#39;d use in order to move Bill&#39;s total to 204?

Increment a value in Postgres

I am beginner to PostgreSQL.

I want to connect to another database from the query editor of Postgres - like the `USE` command of MySQL or MS SQL Server. 
 
I found `\c databasename` by searching the Internet, but its runs only on [psql][1]. When I try it from the PostgreSQL query editor I get a syntax error.

I have to change the database by pgscripting. Does anyone know how to do it?


  [1]: http://www.postgresql.org/docs/current/interactive/app-psql.html

&quot;use database_name&quot; command in PostgreSQL

Using PostgreSQL 9.0, I have a group role called &quot;staff&quot; and would like to grant all (or certain) privileges to this role on tables in a  particular schema. None of the following work

    GRANT ALL ON SCHEMA foo TO staff;
    GRANT ALL ON DATABASE mydb TO staff;

Members of &quot;staff&quot; are still unable to SELECT or UPDATE on the individual tables in the schema &quot;foo&quot; or (in the case of the second command) to any table in the database *unless* I grant all on that specific table.

What can I do make my and my users&#39; lives easier?

**Update:** Figured it out with the help of [a similar question on serverfault.com][1].

    GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA foo TO staff;


  [1]: https://serverfault.com/questions/60508/grant-select-to-all-tables-in-postgresql

Grant all on a specific schema in the db to a group role in PostgreSQL

In PostgreSQL 8 is it possible to add `ON DELETE CASCADES` to the both foreign keys in the following table without dropping the latter?

    # \d scores
            Table &quot;public.scores&quot;
     Column  |         Type          | Modifiers
    ---------+-----------------------+-----------
     id      | character varying(32) |
     gid     | integer               |
     money   | integer               | not null
     quit    | boolean               |
     last_ip | inet                  |
    Foreign-key constraints:
       &quot;scores_gid_fkey&quot; FOREIGN KEY (gid) REFERENCES games(gid)
       &quot;scores_id_fkey&quot; FOREIGN KEY (id) REFERENCES users(id)

Both referenced tables are below - here:

    # \d games
                                         Table &quot;public.games&quot;
      Column  |            Type             |                        Modifiers
    ----------+-----------------------------+----------------------------------------------------------
     gid      | integer                     | not null default nextval(&#39;games_gid_seq&#39;::regclass)
     rounds   | integer                     | not null
     finished | timestamp without time zone | default now()
    Indexes:
        &quot;games_pkey&quot; PRIMARY KEY, btree (gid)
    Referenced by:
        TABLE &quot;scores&quot; CONSTRAINT &quot;scores_gid_fkey&quot; FOREIGN KEY (gid) REFERENCES games(gid)

And here:

    # \d users
                    Table &quot;public.users&quot;
       Column   |            Type             |   Modifiers
    ------------+-----------------------------+---------------
     id         | character varying(32)       | not null
     first_name | character varying(64)       |
     last_name  | character varying(64)       |
     female     | boolean                     |
     avatar     | character varying(128)      |
     city       | character varying(64)       |
     login      | timestamp without time zone | default now()
     last_ip    | inet                        |
     logout     | timestamp without time zone |
     vip        | timestamp without time zone |
     mail       | character varying(254)      |
    Indexes:
        &quot;users_pkey&quot; PRIMARY KEY, btree (id)
    Referenced by:
        TABLE &quot;cards&quot; CONSTRAINT &quot;cards_id_fkey&quot; FOREIGN KEY (id) REFERENCES users(id)
        TABLE &quot;catch&quot; CONSTRAINT &quot;catch_id_fkey&quot; FOREIGN KEY (id) REFERENCES users(id)
        TABLE &quot;chat&quot; CONSTRAINT &quot;chat_id_fkey&quot; FOREIGN KEY (id) REFERENCES users(id)
        TABLE &quot;game&quot; CONSTRAINT &quot;game_id_fkey&quot; FOREIGN KEY (id) REFERENCES users(id)
        TABLE &quot;hand&quot; CONSTRAINT &quot;hand_id_fkey&quot; FOREIGN KEY (id) REFERENCES users(id)
        TABLE &quot;luck&quot; CONSTRAINT &quot;luck_id_fkey&quot; FOREIGN KEY (id) REFERENCES users(id)
        TABLE &quot;match&quot; CONSTRAINT &quot;match_id_fkey&quot; FOREIGN KEY (id) REFERENCES users(id)
        TABLE &quot;misere&quot; CONSTRAINT &quot;misere_id_fkey&quot; FOREIGN KEY (id) REFERENCES users(id)
        TABLE &quot;money&quot; CONSTRAINT &quot;money_id_fkey&quot; FOREIGN KEY (id) REFERENCES users(id)
        TABLE &quot;pass&quot; CONSTRAINT &quot;pass_id_fkey&quot; FOREIGN KEY (id) REFERENCES users(id)
        TABLE &quot;payment&quot; CONSTRAINT &quot;payment_id_fkey&quot; FOREIGN KEY (id) REFERENCES users(id)
        TABLE &quot;rep&quot; CONSTRAINT &quot;rep_author_fkey&quot; FOREIGN KEY (author) REFERENCES users(id)
        TABLE &quot;rep&quot; CONSTRAINT &quot;rep_id_fkey&quot; FOREIGN KEY (id) REFERENCES users(id)
        TABLE &quot;scores&quot; CONSTRAINT &quot;scores_id_fkey&quot; FOREIGN KEY (id) REFERENCES users(id)
        TABLE &quot;status&quot; CONSTRAINT &quot;status_id_fkey&quot; FOREIGN KEY (id) REFERENCES users(id)

And also I wonder if it makes sense to add 2 index&#39;es to the former table?

**UPDATE:** Thank you, and also I&#39;ve got the advice at the mailing list, that I could manage it in 1 statement and thus without explicitly starting a transaction:

    ALTER TABLE public.scores
    DROP CONSTRAINT scores_gid_fkey,
    ADD CONSTRAINT scores_gid_fkey
       FOREIGN KEY (gid)
       REFERENCES games(gid)
       ON DELETE CASCADE;


How to add &quot;on delete cascade&quot; constraints?

Similar to https://stackoverflow.com/questions/29482/cast-int-to-enum-in-c-sharp but my enum is a Generic Type parameter.  What is the *best* way to handle this?

Example:

    private T ConvertEnum&lt;T&gt;(int i) where T : struct, IConvertible
    {
        return (T)i;
    }

Generates compiler error `Cannot convert type &#39;int&#39; to &#39;T&#39;`


Full code is as follows, where value can contain the int, or null.

    private int? TryParseInt(string value)
    {
        var i = 0;
        if (!int.TryParse(value, out i))
        {
            return null;
        }
        return i;
    }
    
    private T? TryParseEnum&lt;T&gt;(string value) where T : struct, IConvertible
    {
        var i = TryParseInt(value);
        if (!i.HasValue)
        {
            return null;
        }
    
        return (T)i.Value;
    }

Cast Int to Generic Enum in C#

I&#39;m trying to debug a program I inherited. This program contains Strings, array lists and collections, lots of casting between types, and I need to do some String manipulations (`substring`, etc.) 

The data _look_ like Strings when printed to the console (e.g., it&#39;s a line of text, like `Johnson, John` or `Chicago Region`), but my code is erroring out with various `index out of range` errors, suggesting that my code to cast to String isn&#39;t working. 

I&#39;d like to try to figure out what data types are coming into and leaving my methods to verify that the program is acting as expected. Is there any way to find a field type in Java? In a perfect world, I could generate console output at every step that would give me the data value and whether it&#39;s a String, array list, or collection. Can that be done?

Is there a way to output the java data type to the console?

I want to accomplish the following

    answer = True
    myvar = &quot;the answer is &quot; + answer

and have myvar&#39;s value be &quot;the answer is True&quot;. I&#39;m pretty sure you can do this in Java.

How do I concatenate a boolean to a string in Python?

I want to determine if a value is integer (like `TryParse` in .NET). Unfortunatelly `ISNUMERIC` does not fit me because I want to parse only integers and not every kind of number. Is there such thing as `ISINT` or something?

Here is some code to make things clear. If `MY_FIELD` is not int, this code would fail:

    SELECT @MY_VAR = CAST(MY_FIELD AS INT)
    FROM MY_TABLE
    WHERE MY_OTHER_FIELD = &#39;MY_FILTER&#39;

Thank you

T-sql - determine if value is integer

As it was the case in Boost, C++11 provides some functions for casting `shared_ptr`:

    std::static_pointer_cast
    std::dynamic_pointer_cast
    std::const_pointer_cast

I am wondering, however, why there are no equivalents functions for `unique_ptr`.

Consider the following simple example:

    class A { virtual ~A(); ... }
    class B : public A { ... }
        
    unique_ptr&lt;A&gt; pA(new B(...));

    unique_ptr&lt;A&gt; qA = std::move(pA); // This is legal since there is no casting
    unique_ptr&lt;B&gt; pB = std::move(pA); // This is not legal

    // I would like to do something like:
    // (Of course, it is not valid, but that would be the idea)
    unique_ptr&lt;B&gt; pB = std::move(std::dynamic_pointer_cast&lt;B&gt;(pA));

Is there any reason why this usage pattern is discouraged, and thus, equivalent functions to the ones present in `shared_ptr` are not provided for `unique_ptr`?

Dynamic casting for unique_ptr

To get timestamp in JavaScript we use 

    var ts = new Date().getTime()

What is the proper way to convert it to a Python `datetime` so far I use the following code

    &gt;&gt;&gt; jsts = 1335205804950
    &gt;&gt;&gt; dt = datetime.datetime.fromtimestamp(jsts/1000)
    &gt;&gt;&gt; dt
    datetime.datetime(2012, 4, 24, 0, 30, 4)

I divide timestamp by 1000 because I get error like 

    ValueError                                Traceback (most recent call last)
    1 d = datetime.datetime.fromtimestamp(a)
    ValueError: year is out of range


Sultan.

JavaScript timestamp to Python datetime conversion

**i.e.** this code 


    startDate = new Date(timestampValue.getTime));

gives me :

**2012-16-02 05:16:17**

when
 
    System.out.println(timestampValue);

return :

**2012-01-02 05:16:17.0**

How to convert from java.sql.Timestamp to java.util.Date?

I have a database table containing dates 

     (`date` timestamp NOT NULL DEFAULT &#39;0000-00-00 00:00:00&#39;). 

I&#39;m using MySQL. From the program sometimes data is passed without the date to the database. So, the date value is auto assigned to `0000-00-00 00:00:00`
when the table data is called with the date column it gives error

    ...&#39;0000-00-00 00:00:00&#39; can not be represented as java.sql.Timestamp.......

I tried to pass null value to the date when inserting data, but it gets assign to the current time.

Is there any way I can get the `ResultSet` without changing the table structure?

&#39;0000-00-00 00:00:00&#39; can not be represented as java.sql.Timestamp error

How do I convert the following format to unix timestamp?

    Apr 15 2012 12:00AM

The format I get from DB seems to have `AM` at the end. 
I&#39;ve tried using the following but it did not work:

    CONVERT(DATETIME, Sales.SalesDate, 103) AS DTSALESDATE,  
    CONVERT(TIMESTAMP, Sales.SalesDate, 103) AS TSSALESDATE

    where Sales.SalesDate value is Apr 15 2012 12:00AM

MySQL convert date string to Unix timestamp

How to convert a `double` value to `int` doing the following:

    Double If x = 4.97542. Convert to int x = 4.
    
    Double If x = 4.23544. Convert to int x = 4.

That is, the answer is always rounding down.

Convert double to Int, rounded down

I need to convert minutes to hours, rounded off to two decimal places. I also need to display only up to two numbers after the decimal point. So if I have minutes as 650, then hours should be 10.83.

Here&#39;s what I have so far:

    Select round(Minutes/60.0,2) from ....

But in this case, if my minutes is, say, 630 - hours is 10.5000000. But I want it as 10.50 only (after rounding). How do I achieve this?




Rounding off to two decimal places in SQL

How do you round a float to 2 decimal places in JRuby(1.6.x)?

&lt;!-- language: lang-ruby --&gt;

    number = 1.1164
    number.round(2)

    # The above shows the following error
    # wrong number of arguments (1 for 0)




How do you round a float to 2 decimal places in JRuby?


I want to set scale of two BigDecimal numbers `a` and `b` . as in this example :

    BigDecimal a = new BigDecimal(&quot;2.6E-1095&quot;);
            BigDecimal b = new BigDecimal(&quot;2.7E-1105&quot;);
            int i = 112, j=1;
    
            BigDecimal aa = a.setScale(i+j);
            BigDecimal bb = b.setScale(i+j);

and when i run i have this exception:

    java.lang.ArithmeticException: Rounding necessary
    	at java.math.BigDecimal.divideAndRound(BigDecimal.java:1439)
    	at java.math.BigDecimal.setScale(BigDecimal.java:2394)
    	at java.math.BigDecimal.setScale(BigDecimal.java:2437)

Why rounding is necessary ?  if i don&#39;t want to make around, what is solution please ?

Thanks

Rounding necessary with BigDecimal numbers

I was just re-reading [What’s New In Python 3.0][1] and it states:

&gt; The round() function rounding strategy and return type have changed.
&gt; Exact halfway cases are now rounded to the nearest even result instead
&gt; of away from zero. (For example, round(2.5) now returns 2 rather than
&gt; 3.)

and
the documentation for [round][2]:

&gt; For the built-in types supporting round(), values are rounded to the
&gt; closest multiple of 10 to the power minus n; if two multiples are
&gt; equally close, rounding is done toward the even choice


So, under **v2.7.3**:

    In [85]: round(2.5)
    Out[85]: 3.0
    
    In [86]: round(3.5)
    Out[86]: 4.0

as I&#39;d have expected. However, now under **v3.2.3**:

    In [32]: round(2.5)
    Out[32]: 2
    
    In [33]: round(3.5)
    Out[33]: 4

This seems counter-intuitive and contrary to what I understand about
rounding (and bound to trip up people). English isn&#39;t my native language but
until I read this I thought I knew what rounding meant :-/  I am sure
at the time v3 was introduced there must have been some discussion of
this, but I was unable to find a good reason in my search.

 1. Does anyone have insight into why this was changed to this?
 2. Are there any other mainstream programming languages (e.g., *C, C++, Java, Perl,* ..) that do this sort of (to  me inconsistent) rounding?

What am I missing here?

UPDATE: @Li-aungYip&#39;s comment re &quot;Banker&#39;s rounding&quot; gave me the right search term/keywords to search for and I found this SO question: https://stackoverflow.com/questions/311696/why-does-net-use-bankers-rounding-as-default, so I will be reading that carefully.



  [1]: http://docs.python.org/py3k/whatsnew/3.0.html
  [2]: http://docs.python.org/release/3.1.5/library/functions.html#round

Content Type	Original Author	Original Content on Stackoverflow
Question	Dipro Sen	View Question on Stackoverflow
Solution 1 - Sql	Erwin Brandstetter	View Answer on Stackoverflow
Solution 2 - Sql	Yuriy Rypka	View Answer on Stackoverflow
Solution 3 - Sql	Shriganesh Kolhe	View Answer on Stackoverflow

Discard millisecond part from timestamp

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

Solution 3 - Sql

GPL/LGPL and Static Linking

How to shutdown my Jenkins safely?

Attributions