1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
|
/*
* $Id: utils.c,v 1.2 2005/06/16 12:41:52 bogdan_iancu Exp $
*
* MySQL module utilities
*
* Copyright (C) 2001-2003 FhG Fokus
*
* This file is part of openser, a free SIP server.
*
* openser is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version
*
* openser is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*
* History:
* -------
* 2003-04-14 tm_isdst in struct tm set to -1 to let mktime
* guess daylight saving (janakj)
*/
#define _XOPEN_SOURCE 4 /* bsd */
#define _XOPEN_SOURCE_EXTENDED 1 /* solaris */
#include <strings.h>
#include <string.h>
#include <time.h> /*strptime, XOPEN issue must be >=4 */
#include "utils.h"
/*
* Convert time_t structure to format accepted by MySQL database
*/
int time2mysql(time_t _time, char* _result, int _res_len)
{
struct tm* t;
/*
if (_time == MAX_TIME_T) {
snprintf(_result, _res_len, "0000-00-00 00:00:00");
}
*/
t = localtime(&_time);
return strftime(_result, _res_len, "%Y-%m-%d %H:%M:%S", t);
}
/*
* Convert MySQL time representation to time_t structure
*/
time_t mysql2time(const char* _str)
{
struct tm time;
/* It is necessary to zero tm structure first */
memset(&time, '\0', sizeof(struct tm));
strptime(_str, "%Y-%m-%d %H:%M:%S", &time);
/* Daylight saving information got lost in the database
* so let mktime to guess it. This eliminates the bug when
* contacts reloaded from the database have different time
* of expiration by one hour when daylight saving is used
*/
time.tm_isdst = -1;
return mktime(&time);
}
|
