Top "Sql-timestamp" questions

Oracle SQL : timestamps in where clause

I need to look up rows within a particular time frame. select * from TableA where startdate >= '12-01-2012 21:24:00…

sql oracle where sql-timestamp
Timestamp conversion in Oracle for YYYY-MM-DD HH:MM:SS format

I'm trying to insert records with YYYY-MM-DD HH:MM:SS format into Oracle from Netezza, but I'm getting invalid date …

sql oracle oracle11g sql-timestamp
Oracle SQL: converting timestamp to UTC

I have a simple select query such as below but I noticed I am getting back the regional times. How …

sql oracle utc sql-timestamp
Hive - month and year from timestamp column

Hi I am trying to extract the month and year part of a timestamp column in hive using the below …

date hadoop hive sql-timestamp
MySQL 1292 Incorrect datetime value

I am getting this error when I try to insert '2011/03/13 02:53:50.000000000' into a timestamp column. If I change the 13 …

mysql sql-timestamp mysql-error-1292
How to convert TIMESTAMP values to VARCHAR in T-SQL as SSMS does?

I am trying to convert a TIMESTAMP field in a table to a string so that it can be printed …

sql-server tsql ssms nvarchar sql-timestamp
SqlAlchemy TIMESTAMP 'on update' extra

I am using SqlAlchemy on python3.4.3 to manage a MySQL database. I was creating a table with: from datetime import …

python mysql python-3.x sqlalchemy sql-timestamp
Convert special String into Date in H2

There is a SQL function from Oracle to_date('26 Jul 2016, 05:15:58 AM','DD Mon YYYY, HH:MI:SS AM'), and …

sql oracle h2 sql-timestamp
How do I make doctrine support timestamp columns?

I'm trying to apply the following migration: Schema::table('users', function (Blueprint $table) { $table->timestamp('created_at')->…

php doctrine-orm database-migration laravel-5.2 sql-timestamp
How to implement created_at and updated_at column using Room Persistence ORM tools in android

How can I implement created_at and updated_at columns using Room Persistence ORM tools in Android, that can update …

java android orm android-room sql-timestamp