Re: Dating Advice

From: Ewoud Dronkert (firstname_at_lastname.net.invalid)
Date: 02/24/05 

Date: Thu, 24 Feb 2005 08:10:55 +0100

On 23 Feb 2005 02:10:53 -0800, relaxory wrote:
> It's just a pain you know :)

What, 2 simple queries?

alter table t1 add d2 as date;
update t1 set d2=concat_ws('-',right(d1,4),mid(d1,3,2),left(d1,2)); 

-- 
Firefox Web Browser - Rediscover the web - http://getffox.com/
Thunderbird E-mail and Newsgroups - http://gettbird.com/

Relevant Pages

  • MaxLocksPerFile Message
    ... alter table queries in a macro. ... increase the settings and what the settings should be? ...
    (microsoft.public.access.queries)
  • Re: Rename a view that has dependent views
    ... but that's such a pain! ... first view's name appears multiple times in the view definition. ... I wonder why sp_rename doesn't fix syscomments? ... but will not alter its text in the syscomments ...
    (microsoft.public.sqlserver.tools)
  • Re: Question on choosing primary key; real or arbitrary
    ... "Watch the order of the columns, so you can take advantage of the indexing; ... that is the real trick." ... ALTER TABLE dbo.INVENTORY_DATA1 ... The 3 most common queries will be as follows ...
    (microsoft.public.sqlserver.programming)
  • Scheduler Tasks
    ... I find it a great pain to have to reset every Scheduled ... The company will not alter their policy of 30 day password ...
    (microsoft.public.win2000.security)
  • Re: Is there a way to add a new column to a table while the table is being used for queries???
    ... alter table  MyTable add column mynewfield clob; ... How do I insure that users can continue to make queries on the ... type environment. ...
    (comp.databases.oracle.misc)