Project

General

Profile

Actions

Feature proposal #6589

closed

Implement parsing of date fields into storeable values

Added by krileon almost 7 years ago. Updated over 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
17 April 2017
Due date:
% Done:

100%

Estimated time:

Description

Currently social sites may not provide standard SQL formatted dates. Run them safely (try catch) through date parsing to format as SQL values so they can be properly stored.

Actions #1

Updated by krileon over 6 years ago

This probably should be done on a provider by provider basis with a function to simply treat certain profile variables as dates and handle the conversion at once.

Actions #2

Updated by krileon over 6 years ago

Maybe instead of forcing this for every date field simply provide an additional field mapping usage of formatted. Example options as follows.

birthday
birthday (Formatted)

Where (Formatted) usage would be formatted to SQL date.

Actions #3

Updated by krileon over 6 years ago

Best solution is to simply check what type of field is attempting to be mapped and format accordingly (e.g. if something is being mapped to a date field ensure it's formatted for a date field).

Actions #4

Updated by krileon over 6 years ago

  • Status changed from Assigned to Resolved
  • % Done changed from 0 to 100

If a value is mapped to a date or datetime field it will not attempt to convert it to SQL safe.

Actions #5

Updated by krileon over 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF