Add serial date field, sql
Posted on 2014-10-02
I am very new to SQL and honestly not very good at it yet. I depend on the kindness of others sharing their knowledge like yourselves when faced with an issue.
I need to add a field to a couple of tables in SQL that contain a standard date (date format) or they maybe VARCHAR format so we may need two different solutions. What I need to do is to take that date field and add a new field that would provide the date in serial format. (example: 10/2/2014 would be 41914) Again, some tables have the date in a varchar format so I guess that really isn't a date, at least as far as SQL is concerned so this would have to be converted to a date first then to a serial date. Other tables have the date in a DATE format already.
Any help would be greatly appreciated.