##to_timestamp()
You need to use `to_timestamp()` to convert your string to a proper `timestamp` value:

    to_timestamp(&#39;12-01-2012 21:24:00&#39;, &#39;dd-mm-yyyy hh24:mi:ss&#39;)

##to_date()
If your column is of type `DATE` (which also supports seconds), you need to use `to_date()`

    to_date(&#39;12-01-2012 21:24:00&#39;, &#39;dd-mm-yyyy hh24:mi:ss&#39;)

##Example
To get this into a `where` condition use the following:

    select * 
    from TableA 
    where startdate &gt;= to_timestamp(&#39;12-01-2012 21:24:00&#39;, &#39;dd-mm-yyyy hh24:mi:ss&#39;)
      and startdate &lt;= to_timestamp(&#39;12-01-2012 21:25:33&#39;, &#39;dd-mm-yyyy hh24:mi:ss&#39;)

##Note
You never need to use `to_timestamp()` on a column that is of type `timestamp`.




For everyone coming to this thread with fractional seconds in your timestamp use:

&lt;code&gt;to_timestamp(&#39;2018-11-03 12:35:20.419000&#39;, &#39;YYYY-MM-DD HH24:MI:SS.FF&#39;)&lt;/code&gt;


In Twig template I check if a field has an error like this:

    {% if form.points.get(&#39;errors&#39;) is not empty %}

Is there any method like:

    {% if form.points.hasErrors() %}

to do it simpler? It&#39;s not a big difference, but if I can&#39;t do it easier why not.



Simple check if form field has errors in Twig template

***Note:*** *Unfortunately this question was closed, but I&#39;m trying to maintain it for if someone else comes along with the same question.*

I&#39;ve been looking for a good solution to developing a service in Scala that will sit between mobile devices and existing web services.

The current list of viable options are:

 - [Finagle][1]
 - [Spray][2]
 - [BlueEyes][3]
 - [Akka][4]
 - [Play2 Mini][5]
 - [Unfiltered][6]
 - [Lift][7]
 - [Smoke][8]
 - [Scalatra][11]

There are probably more options out there. How does one decide which one to use? What are the traits (excuse the pun ;-) of a good Scala middleware choice. On the one side, I would like to go for Akka, because it is part of the TypeSafe Scala stack, but on the other, something like Finagle has a rich set of libraries and makes plumbing so easy. Spray looks nice and simple to use.

Any advice, insights or experience would be greatly appreciated. I&#39;m sure someone out there must have some experience with some of these that they won&#39;t mind sharing.

**UPDATE:**

I would love for this question to be reopened. A good answer to this question will help new Scalateers to avoid related pitfalls.

**UPDATE 2:**

These are my own experiences since asking this question:

*Finagle* - I used Finagle for a project and it&#39;s rock solid.

*Spray* - In my latest project I&#39;m using Spray and I&#39;m extremely happy. The latest releases are built on Akka 2 and you can run it directly with the Spray-can library which removes the need for a web server. Spray is a set of libraries, rather than a framework and is very modular. The [Learn about Spray: REST on Akka video][9] gives a great overview, and [this blog at Cakesolutions][10] shows a really nice development approach and architecture.

**UPDATE 3:**

Life moves pretty fast. If you don&#39;t stop and look around once in a while, you could miss it. - _Ferris Bueller_

These days the choice has become simpler. In my humble opinion Spray has won the battle. It is being [integrated into Akka][12] to become the next Akka HTTP. I have been using Spray now on multiple projects and can honestly say that it&#39;s fantastic and best supported software I have ever encountered.

This does not answer the initial question, but at least gives some indication on why Spray seems like the best choice in most cases. It is extremely flexible, non-blocking and very stable. It has both client-side and server-side libraries and a great testkit. Also, have a look at these stats to get an idea on performance: [Web Framework Benchmarks][13]

  [1]: http://twitter.github.com/finagle
  [2]: https://github.com/spray
  [3]: https://github.com/jdegoes/blueeyes
  [4]: http://akka.io/
  [5]: https://github.com/typesafehub/play2-mini/
  [6]: http://unfiltered.databinder.net/Unfiltered.html
  [7]: http://liftweb.net/
  [8]: https://github.com/mDialog/smoke
  [9]: http://marakana.com/s/spray_rest_on_akka_from_the_northeast_scala_symposium,1150/index.html
  [10]: http://www.cakesolutions.net/teamblogs/2012/07/29/api-first-rest-in-akka-and-spray/
  [11]: http://www.scalatra.org/
  [12]: http://typesafe.com/blog/typesafe-gets-sprayed
  [13]: http://www.techempower.com/benchmarks/#section=data-r7&amp;hw=i7&amp;test=json

What are the differences between Scala middleware choices?

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 need to look up rows within a particular time frame.
<pre><code class="hljs language-csharp">select * 
from TableA 
where startdate >= '12-01-2012 21:24:00' 
 and startdate &#x3C;= '12-01-2012 21:25:33'
</code></pre>
I.e.: I need to look up rows with timestamp precision of SECONDS. How do I achieve this?
FYI: The <code>startdate</code> column is of type <code>TIMESTAMP</code>.

I have a table called `provider`. I have three columns called `person`, `place`, `thing`. There can be duplicate persons, duplicate places, and duplicate things, but there can never be a dupicate person-place-thing combination.

How would I ALTER TABLE to add a composite primary key for this table in MySQL with the these three columns?

ALTER TABLE to add a composite primary key

I want to select rows according to the month of a `date` or `timestamp` column like this:

    SELECT id, name,&#160;birthday 
    FROM employee.person 
    WHERE Month(birthday) &gt; 10;

But I only get error messages in PostgreSQL.  
How can this be done?

Selecting by month in PostgreSQL

Here is model:

    class User(Base):
        ...
        birthday = Column(Date, index=True)   #in database it&#39;s like &#39;1987-01-17&#39;
        ...

I want to filter between two dates, for example to choose all users in interval 18-30 years.

How to implement it with SQLAlchemy?

I think of:

    query = DBSession.query(User).filter(
        and_(User.birthday &gt;= &#39;1988-01-17&#39;, User.birthday &lt;= &#39;1985-01-17&#39;)
    ) 
    
    # means age &gt;= 24 and age &lt;= 27
I know this is not correct, but how to do correct?


SQLAlchemy: how to filter date field?

I&#39;m using Postgres and would like to make a big update query that would pick up from a CSV file, lets say I got a table that&#39;s got `(id, banana, apple)`.

I&#39;d like to run an update that changes the Bananas and not the Apples, each new Banana and their ID would be in a CSV file.

I tried looking at the Postgres site but the examples are killing me.

How to update selected rows with values from a CSV file in Postgres?

I&#39;d like to get sum of column1, sum of column2 and total sum. In Postgres I can do it this way: **(notice the star)**

    SELECT *, a+b AS total_sum FROM
    (
       SELECT SUM(column1) AS a, SUM(column2) AS b
       FROM table
    )

But in Oracle I get an syntax error and have to use this:

    SELECT a,b, a+b AS total_sum FROM
    (
       SELECT SUM(column1) AS a, SUM(column2) AS b
       FROM table
    )

I have really lot of columns to return so I do not want to write the column names again in the main query. Is there any easy solution?

I cannot use a+b in the inner query because there are not known at this place.
I do not want to use `SELECT SELECT SUM(column1) AS a, SUM(column2) AS b, SUM(column1)+SUM(column2) AS total_sum`.



Select * from subquery

I want to use oracle syntax to select only 1 row from table `DUAL`.  For example, I want to execute this query:

    SELECT user 
      FROM DUAL

...and it&#39;d have, like, 40 records.  But I need only one record.  ...AND, I want to make it happen without a `WHERE` clause.

I need something in the table_name field such as:

    SELECT FirstRow(user) 
      FROM DUAL



How to select only 1 row from oracle sql?

what is the different between timestamp data type without parameter and with parameter 0:

`timestamp` VS `timestamp(0)`




Oracle timestamp data type

I need to get the name of the primary key column. 

In the input, I only have the table name. 

How to get primary key column in Oracle?

Is it possible, in PLSQL, to select all of the fields in a table except for 1 or 2, without having to specify the fields you want?

Example, the employee table has the fields:   


 - id
 - firstname
 - lastname
 - hobbies

Is it still possible to write a query similar to 

    select * from employee

while leaving the field `hobbies` without with having to write something like this?

    select id, firstname, lastname from employee



Can you SELECT everything, but 1 or 2 fields, without writer&#39;s cramp?

I would like to know how to use NULL and an empty string at the same time in a `WHERE` clause in SQL Server. I need to find records that have either null values or an empty string. Thanks.

How to use NULL or empty string in SQL

How do I use the `created_at` field to get only the records that were created today and no other day or time?

I was thinking of a `-&gt;where(&#39;created_at&#39;, &#39;&gt;=&#39;, Carbon::now())` But Im not sure that would work.

Get only records created today in laravel

The Swift documentation at page 61 of the Swift manual hints to the possibility of using `where` to join an optional binding with a regular condition. Yet when I do it I have a warning suggesting me to substitute the `where` with a comma like in the following piece of code:

    if let geocodingError = error as? NSError where geocodingError.code == 2

Content Type	Original Author	Original Content on Stackoverflow
Question	sid	View Question on Stackoverflow
Solution 1 - Sql	a_horse_with_no_name	View Answer on Stackoverflow
Solution 2 - Sql	jyapx	View Answer on Stackoverflow

Oracle SQL : timestamps in where clause

Sql Problem Overview

Sql Solutions

Solution 1 - Sql

Solution 2 - Sql

What are the differences between Scala middleware choices?

Simple check if form field has errors in Twig template

Attributions