As a general rule, my preferred date format is now YYYY-MM-DD HH:MI:SS
This format works (with only a small caveat) in all of the DBMS I'm currently using, Oracle, SQL Server and DB2.
The caveat is for Oracle which requires an alter session to work, easily done in a login script.
PS: By 'works' I mean that date/time functions in each of the DBMS can parse this date format without the use of any conversion functions, e.g. convert (SQL Server), to_date (Oracle).
I'm currently using Aqua DataStudio for database access.
It ships with all the JDBC drivers it needs and can connect to all of the above DBMS.
The only problem, it is $400 per user - but it's worth it.
KSH, Bash - not mad keen on CSH though
SQL, T-SQL, PL/SQL to name but 3 varieties.
Powershell 2.0 is available for download.
Note that Windows XP users require SP3 to install.
Windows 7 and 2008 come with Powershell 2.0 pre-installed.
| link | Add spreadsheet-like calc. to form input fields [ Brian Huff ] |
|---|---|
| link | The incredible em and elastic layouts with css [ Jon Tan ] |
PHP Drivers for SQL Server
http://www.microsoft.com/downloads/en/details.aspx?displaylang=en&FamilyID=80e44913-24b4-4113-8807-caae6cf2ca05
How to use MS PDO drivers
http://www.yiiframework.com/wiki/192/config-use-ms-sql-server-2005-2008