Tags » Datetime

Turn Unusable Date into usable SQL DateTime

We had situation where we had an application that feed a varchar date into a column that was not usable to our BI report writers. The column had 3 months letters and a space and the year which was numeric. 399 more words

SQL

ACL Error: Not all Fields Imported via Script

Recently, I  ran an import script to import a delimited file into ACL, but the last 10 fields were not imported. And I didn’t know it right away, because I received no error message. 402 more words

ACL

Convert mysql Date and Time to user friendly format


Formatting Date/Time is an essential thing for any software applications. This Date/Time formatting can be done using with programming language or while retrieving date from the data base using sql queries. 169 more words

PHP

Date and time

Getting the current date and time:

from datetime import datetime
now=datetime.now()
print now

This will print the current time for e.g.

2014-08-01 10:43:06.356313

For a different format: 46 more words

Codes

JSR-310 Java 8 Date Time Presentation at IL Java User Group

Yesterday I presented Java 8 Date Time new feature.

The presentation took place at the Israeli Java User Group meetup (ILJUG).

Here’s the presentation:

http://www.slideshare.net/egolan74/date-time-java-8-jsr-310

Java

Convert .NET Date/Time Formats for JavaScript UI Controls

I recently had a project where I was using ASP.NET and C# to build an application that made use of JQuery Datepicker as well as a third-party… 301 more words

Dev

How to change the timezone on a Ubuntu server

A very simple and quick fix to a rather annoying (especially when searching log files!) issue, is changing the server timezone.

To check your the current date and time on your server, simply run: 40 more words

How-to