Download Time & date scripts

«« « 1 » »»
336 336

It can be used to show the future dates for upcoming weekdays/weekends.

Sql | Sep 11, 2010 | downloaded 2 script(s) | MSSQL

The script is only useful in places where date values are being stored in integer values.

Sql | Sep 11, 2010 | downloaded 2 script(s) | MSSQL

The minimum input date is 1900-01-01 00:00:000.

Sql | Sep 11, 2010 | downloaded 1 script(s) | MSSQL

This SQL script creates a 12 month calendar for any given year.

Sql | Sep 13, 2010 | downloaded 3 script(s) | N/A

A format YYYYMMDDHHMMSS is converted to a datetime variable.

Sql | Sep 13, 2010 | downloaded 2 script(s) | N/A

The HH:MM:SS format is changed to HH:MM am/pm.

Sql | Sep 13, 2010 | downloaded 2 script(s) | Oracle

The time is rounded to the nearest hour, half hour or quarter hour.

Sql | Sep 14, 2010 | downloaded 1 script(s) | N/A

After creating the column it then verifies the validity of the data using the CHECK constraint.

Sql | Sep 14, 2010 | downloaded 2 script(s) | N/A

It will convert a standard date to milliseconds.

Sql | Sep 14, 2010 | downloaded 5 script(s) | Oracle

It needs as input a date in Greenwich format.

Sql | Sep 14, 2010 | downloaded 3 script(s) | MSSQL

It will return Y or N if the date satisfies the condition.

Sql | Sep 15, 2010 | downloaded 3 script(s) | Oracle

It returns the hours, minutes and seconds in a new field named Elap_time.

Sql | Sep 15, 2010 | downloaded 3 script(s) | N/A

The SQL script will convert TIMESTAMP values to numeric values.

Sql | Sep 15, 2010 | downloaded 3 script(s) | N/A

It handles similar to the classic SQL server, DATEADD function.

Sql | Sep 15, 2010 | downloaded 2 script(s) | N/A

YYYY-MM-DD is the standard format.

Sql | Sep 15, 2010 | downloaded 2 script(s) | N/A

· The script will perform only conversions, and not date operations.

Sql | Sep 16, 2010 | downloaded 6 script(s) | N/A

If not, it will add or subtract from the date and time value to correct it.

Sql | Sep 16, 2010 | downloaded 4 script(s) | N/A

In combination with other scripts it can also strip out or manage those dates.

Sql | Sep 16, 2010 | downloaded 3 script(s) | N/A

It can be used to manipulate date formats, apply filters based on weeks or other time formats or process statements at various intervals or set times.

Sql | Sep 16, 2010 | downloaded 2 script(s) | N/A

If a user enters a day ['Tuesday'], the script finds all the dates of all the Tuesdays of a month.

Sql | Sep 16, 2010 | downloaded 4 script(s) | N/A

The output data of the script can be used in any way desired.

Sql | Sep 16, 2010 | downloaded 2 script(s) | N/A

The database includes all timestamps of daylight saving time (DST) as well.

Sql | May 20, 2011 | downloaded 5 script(s) | N/A

«« « 1 » »»